Final-wolffa24
Alex Wolff
2024-04-18
Load Packages
library(tidyverse)
library(ggmap)
library(tidygeocoder)
library(maps)
library(zoo)
library(lubridate)
library(knitr)
library(kableExtra)
library(ggrepel)
library(RMySQL)
library(gridExtra)
library(reshape2)
library(geosphere)
set.seed(2024)Part 1 – Web Scraping & Geospatial Mapping – Breweries, Meaderies, Cideries, and Sake Producers
Question 1
nc_breweries <- read_csv("/home/ballengerb@ad.wlu.edu/BUS_317_01/wolffa24/Data/nc_breweries.csv")
nc_cideries <- read_csv("/home/ballengerb@ad.wlu.edu/BUS_317_01/wolffa24/Data/nc_cideries.csv")
nc_meaderies <- read_csv("/home/ballengerb@ad.wlu.edu/BUS_317_01/wolffa24/Data/nc_meaderies.csv")
nc_sake_producers <- read_csv("/home/ballengerb@ad.wlu.edu/BUS_317_01/wolffa24/Data/nc_sake_producers.csv")
ncbreweries <- bind_rows(nc_breweries, nc_cideries, nc_meaderies, nc_sake_producers) %>%
mutate(state="North Carolina")
write.csv(ncbreweries, "/home/ballengerb@ad.wlu.edu/BUS_317_01/wolffa24/Data/ncbreweries.csv", row.names = FALSE)Question 2
ca_breweries <- read_csv("/home/ballengerb@ad.wlu.edu/BUS_317_01/wolffa24/Data/ca_breweries.csv")
ca_cideries <- read_csv("/home/ballengerb@ad.wlu.edu/BUS_317_01/wolffa24/Data/ca_cideries.csv")
ca_meaderies <- read_csv("/home/ballengerb@ad.wlu.edu/BUS_317_01/wolffa24/Data/ca_meaderies.csv")
ca_sake_producers <- read_csv("/home/ballengerb@ad.wlu.edu/BUS_317_01/wolffa24/Data/ca_sake_producers.csv")
cabreweries <- bind_rows(ca_breweries, ca_cideries, ca_meaderies, ca_sake_producers)%>%
mutate(state="California")
write.csv(cabreweries, "/home/ballengerb@ad.wlu.edu/BUS_317_01/wolffa24/Data/cabreweries.csv", row.names = FALSE)Question 3
breweries <- bind_rows(ncbreweries, cabreweries)
write.csv(breweries, "/home/ballengerb@ad.wlu.edu/BUS_317_01/wolffa24/Data/breweries.csv", row.names = FALSE)
breweries <- breweries %>%
mutate(status = "active",
beverage_count = as.numeric(str_trim(beverage_count)),
type = factor(type,
levels = c("Brewpub/Brewery", "Microbrewery", "Brewpub", "Client Brewer", "Commissioner",
"Meadery", "Cidery", "Sake Producer", "Contract Brewer", "Commercial Brewery"),
labels = c("Brewpub/Brewery", "Microbrewery", "Brewpub", "Client Brewer", "Commissioner",
"Meadery", "Cidery", "Sake Producer", "Contract Brewer", "Commercial Brewery")))glimpse(breweries)## Rows: 1,410
## Columns: 8
## $ name <chr> "12 Bones Brewing", "1718 Brewing Ocracoke", "3rd Rock …
## $ url <chr> "https://www.ratebeer.com/brewers/12-bones-brewing/4010…
## $ city <chr> "Arden", "Ocracoke", "Trenton", "Winston-Salem", "Chero…
## $ type <fct> Brewpub, Brewpub, Microbrewery, Client Brewer, Client B…
## $ established <dbl> 2019, 2018, 2016, 2019, 2018, 2018, 2020, 2018, 2014, 2…
## $ beverage_count <dbl> 14, 38, 14, 4, 8, 12, 15, 18, 24, 17, 7, 152, 51, 13, 1…
## $ state <chr> "North Carolina", "North Carolina", "North Carolina", "…
## $ status <chr> "active", "active", "active", "active", "active", "acti…breweries %>%
head(20) %>%
kable() %>%
kable_styling() %>%
scroll_box(width = "100%", height = "400px")| name | url | city | type | established | beverage_count | state | status |
|---|---|---|---|---|---|---|---|
| 12 Bones Brewing | https://www.ratebeer.com/brewers/12-bones-brewing/40107/ | Arden | Brewpub | 2019 | 14 | North Carolina | active |
| 1718 Brewing Ocracoke | https://www.ratebeer.com/brewers/1718-brewing-ocracoke/35300/ | Ocracoke | Brewpub | 2018 | 38 | North Carolina | active |
| 3rd Rock Brewing Company | https://www.ratebeer.com/brewers/3rd-rock-brewing-company/27344/ | Trenton | Microbrewery | 2016 | 14 | North Carolina | active |
| 638 Brewing Company | https://www.ratebeer.com/brewers/638-brewing-company/38962/ | Winston-Salem | Client Brewer | 2019 | 4 | North Carolina | active |
| 7 Clans Brewing | https://www.ratebeer.com/brewers/7-clans-brewing/35021/ | Cherokee | Client Brewer | 2018 | 8 | North Carolina | active |
| All Sevens Brewing | https://www.ratebeer.com/brewers/all-sevens-brewing/36948/ | Asheville | Microbrewery | 2018 | 12 | North Carolina | active |
| Altered State Brewing Company | https://www.ratebeer.com/brewers/altered-state-brewing-company/44848/ | Raleigh | Microbrewery | 2020 | 15 | North Carolina | active |
| Ancillary* Fermentation | https://www.ratebeer.com/brewers/ancillary-fermentation/37974/ | Raleigh | Commercial Brewery | 2018 | 18 | North Carolina | active |
| Andrews Brewing Company | https://www.ratebeer.com/brewers/andrews-brewing-company/18735/ | Andrews | Microbrewery | 2014 | 24 | North Carolina | active |
| Angry Troll Brewing | https://www.ratebeer.com/brewers/angry-troll-brewing/30127/ | Elkin | Microbrewery | 2017 | 17 | North Carolina | active |
| Appalachian Grail Brewing Company | https://www.ratebeer.com/brewers/appalachian-grail-brewing-company/48590/ | Hayesville | Microbrewery | 2022 | 7 | North Carolina | active |
| Appalachian Mountain Brewery | https://www.ratebeer.com/brewers/appalachian-mountain-brewery/16180/ | Boone | Microbrewery | 2013 | 152 | North Carolina | active |
| Archetype Brewing | https://www.ratebeer.com/brewers/archetype-brewing/32342/ | Asheville | Microbrewery | 2017 | 51 | North Carolina | active |
| Armored Cow Brewing | https://www.ratebeer.com/brewers/armored-cow-brewing/42461/ | Charlotte | Microbrewery | 2020 | 13 | North Carolina | active |
| Asheville Brewing Company | https://www.ratebeer.com/brewers/asheville-brewing-company/3470/ | Asheville | Brewpub | 2003 | 102 | North Carolina | active |
| Ass Clown Brewing Company | https://www.ratebeer.com/brewers/ass-clown-brewing-company/13421/ | Cornelius | Microbrewery | 2011 | 175 | North Carolina | active |
| Aviator Brewing Company | https://www.ratebeer.com/brewers/aviator-brewing-company/10050/ | Fuquay Varina | Microbrewery | 2008 | 69 | North Carolina | active |
| Balsam Falls Brewing Company | https://www.ratebeer.com/brewers/balsam-falls-brewing-company/35306/ | Sylva | Microbrewery | 2018 | 37 | North Carolina | active |
| Bark Brewing Company | https://www.ratebeer.com/brewers/bark-brewing-company/37807/ | Greensboro | Brewpub | 2018 | 1 | North Carolina | active |
| BDD Brewing Company | https://www.ratebeer.com/brewers/bdd-brewing-company/37980/ | Rocky Mount | Microbrewery | 2018 | 9 | North Carolina | active |
for(i in names(breweries)) {
if (!i %in% c("url", "name", "status", "city")) {
if (is.numeric(breweries[[i]])) {
hist <- ggplot(data = breweries, aes_string(x = i)) +
geom_histogram(bins = 30) +
theme_minimal() +
labs(title = paste("Histogram of", i))
print(hist)
} else {
p <- ggplot(data = breweries, aes_string(x = i)) +
geom_bar() +
theme_minimal() +
labs(title = paste("Bar Chart of", i)) +
theme(axis.text.x = element_text(angle = 45, hjust = 1))
print(p)
}}}
Question 4
#breweries_long_lat <- breweries %>%
#distinct(city, state) %>%
#mutate(location = paste(city, state, sep = ", ")) %>%
#tidygeocoder::geocode(location, method = "arcgis")
#write.csv(breweries_long_lat, "/home/ballengerb@ad.wlu.edu/BUS_317_01/wolffa24/Data/breweries_long_lat.csv", row.names = FALSE)breweries_long_lat <- read_csv("/home/ballengerb@ad.wlu.edu/BUS_317_01/wolffa24/Data/breweries_long_lat.csv")
glimpse(breweries_long_lat)## Rows: 497
## Columns: 5
## $ city <chr> "Arden", "Ocracoke", "Trenton", "Winston-Salem", "Cherokee", …
## $ state <chr> "North Carolina", "North Carolina", "North Carolina", "North …
## $ location <chr> "Arden, North Carolina", "Ocracoke, North Carolina", "Trenton…
## $ lat <dbl> 35.46377, 35.11468, 35.06359, 36.09626, 35.47703, 35.59591, 3…
## $ long <dbl> -82.51498, -75.98393, -77.35362, -80.24374, -83.32061, -82.55…breweries_long_lat %>%
head(20) %>%
kable() %>%
kable_styling() %>%
scroll_box(width = "100%", height = "400px")| city | state | location | lat | long |
|---|---|---|---|---|
| Arden | North Carolina | Arden, North Carolina | 35.46377 | -82.51498 |
| Ocracoke | North Carolina | Ocracoke, North Carolina | 35.11468 | -75.98393 |
| Trenton | North Carolina | Trenton, North Carolina | 35.06359 | -77.35362 |
| Winston-Salem | North Carolina | Winston-Salem, North Carolina | 36.09626 | -80.24374 |
| Cherokee | North Carolina | Cherokee, North Carolina | 35.47703 | -83.32061 |
| Asheville | North Carolina | Asheville, North Carolina | 35.59591 | -82.55004 |
| Raleigh | North Carolina | Raleigh, North Carolina | 35.78130 | -78.64168 |
| Andrews | North Carolina | Andrews, North Carolina | 35.20019 | -83.82705 |
| Elkin | North Carolina | Elkin, North Carolina | 36.24811 | -80.85167 |
| Hayesville | North Carolina | Hayesville, North Carolina | 35.04568 | -83.81843 |
| Boone | North Carolina | Boone, North Carolina | 36.20401 | -81.66943 |
| Charlotte | North Carolina | Charlotte, North Carolina | 35.22379 | -80.84114 |
| Cornelius | North Carolina | Cornelius, North Carolina | 35.48491 | -80.85885 |
| Fuquay Varina | North Carolina | Fuquay Varina, North Carolina | 35.58371 | -78.80085 |
| Sylva | North Carolina | Sylva, North Carolina | 35.37365 | -83.22472 |
| Greensboro | North Carolina | Greensboro, North Carolina | 36.07270 | -79.79390 |
| Rocky Mount | North Carolina | Rocky Mount, North Carolina | 35.93903 | -77.80024 |
| Bear Creek | North Carolina | Bear Creek, North Carolina | 35.61683 | -79.38493 |
| NA | North Carolina | NA, North Carolina | 35.53934 | -79.18542 |
| Wendell | North Carolina | Wendell, North Carolina | 35.78449 | -78.37090 |
Question 5
q5_data <- breweries %>%
filter(type %in% c("Cidery", "Meadery", "Sake Producer")) %>%
group_by(state, city, type) %>%
summarise(count = n(), .groups = 'drop') %>%
inner_join(breweries_long_lat)
generate_map <- function(state_name) {
state_data <- q5_data %>% filter(state == state_name)
get_map(location = state_name, zoom = 6, source = "stadia", maptype = "stamen_toner_lite") %>%
ggmap(base_layer = ggplot(state_data, aes(x = long, y = lat, size = count, color = type))) +
geom_point(alpha = 0.6) +
scale_size(range = c(3, 12)) +
theme_void() +
labs(title = paste("Cideries, Meaderies, and Sake Producers in", state_name))
}
map_nc <- generate_map("North Carolina")
map_ca <- generate_map("California")
grid.arrange(map_nc, map_ca, nrow = 2)
Question 6
cities_la <- c("Los Angeles", "Anaheim", "Burbank", "Carson", "Chino", "Chino Hills",
"Compton", "Costa Mesa", "Corona", "Diamond Bar", "Fontana", "Fullerton",
"Garden Grove", "Glendale", "Hesperia", "Huntington Beach", "Inglewood",
"Irvine", "Laguna Beach", "Lancaster", "Long Beach", "Menifee", "Mission Viejo",
"Moreno Valley", "Murrieta", "Newport Beach", "Norwalk", "Ontario", "Orange",
"Oxnard", "Palmdale", "Pasadena", "Pomona", "Rancho Cucamonga", "Rialto",
"Riverside", "San Dimas", "San Bernardino", "San Clemente", "Santa Ana",
"Santa Clarita", "Santa Monica", "Simi Valley", "Thousand Oaks", "Temecula",
"Torrance", "Tustin", "Ventura", "Victorville", "West Covina", "Westminster", "Whittier")
cities_sf <- c("Alameda", "Albany", "American Canyon", "Antioch", "Atherton", "Belmont",
"Belvedere", "Benicia", "Berkeley", "Brentwood", "Brisbane", "Burlingame",
"Calistoga", "Campbell", "Clayton", "Cloverdale", "Colma", "Concord",
"Corte Madera", "Cotati", "Cupertino", "Daly City", "Danville", "Dixon",
"Dublin", "East Palo Alto", "El Cerrito", "Emeryville", "Fairfax",
"Fairfield", "Foster City", "Fremont", "Gilroy", "Half Moon Bay", "Hayward",
"Healdsburg", "Hercules", "Hillsborough", "Lafayette", "Larkspur",
"Livermore", "Los Altos", "Los Altos Hills", "Los Gatos", "Martinez",
"Menlo Park", "Mill Valley", "Millbrae", "Milpitas", "Monte Sereno",
"Moraga", "Morgan Hill", "Mountain View", "Napa", "Newark", "Novato",
"Oakland", "Oakley", "Orinda", "Pacifica", "Palo Alto", "Petaluma",
"Piedmont", "Pinole", "Pittsburg", "Pleasant Hill", "Pleasanton",
"Portola Valley", "Redwood City", "Richmond", "Rio Vista", "Rohnert Park",
"Ross", "St. Helena", "San Anselmo", "San Bruno", "San Carlos",
"San Francisco", "San Jose", "San Leandro", "San Mateo", "San Pablo",
"San Rafael", "San Ramon", "Santa Clara", "Santa Rosa", "Saratoga",
"Sausalito", "Sebastopol", "Sonoma", "South San Francisco", "Suisun City",
"Sunnyvale", "Tiburon", "Union City", "Vacaville", "Vallejo",
"Walnut Creek", "Windsor", "Woodside", "Yountville")options(ggrepel.max.overlaps = Inf)
q6_data <- breweries %>%
filter(type %in% c("Brewpub", "Microbrewery", "Client Brewer", "Brewpub/Brewery", "Commissioner")) %>%
group_by(state, city, type) %>%
summarise(count = n(), .groups = 'drop') %>%
inner_join(breweries_long_lat)
generate_map <- function(city_name, cities) {
city_data <- q6_data %>% filter(city %in% cities)
get_map(location = city_name, zoom = 9, source = "stadia", maptype = "stamen_toner_lite") %>%
ggmap(base_layer = ggplot(city_data, aes(x = long, y = lat, size = count, color = type))) +
geom_point(alpha = 0.6) +
scale_size(range = c(3, 12)) +
theme_void() +
labs(title = paste("Breweries in", city_name))
}
map_la <- generate_map("Los Angeles", cities_la)
map_sf <- generate_map("San Francisco", cities_sf)
grid.arrange(map_la, map_sf, nrow = 2)
Question 7
breweries_url <- breweries %>%
filter(state == "California",
!(type %in% c("Contract Brewers", "Commercial Brewers", "Cidery", "Meadery", "Sake Producer"))) %>%
group_by(city) %>%
filter(n() >= 10) %>%
ungroup %>%
select(url)
write.csv(breweries_url, "/home/ballengerb@ad.wlu.edu/BUS_317_01/wolffa24/Data/breweries_url.csv", row.names = FALSE)#ca_addresses <- read_csv("/home/ballengerb@ad.wlu.edu/BUS_317_01/wolffa24/Data/octoparse_addresses.csv") %>%
#tidygeocoder::geocode(address, method = "census")
#write.csv(ca_addresses, "/home/ballengerb@ad.wlu.edu/BUS_317_01/wolffa24/Data/ca_addresses.csv", row.names = FALSE)ca_addresses <- read_csv("/home/ballengerb@ad.wlu.edu/BUS_317_01/wolffa24/Data/ca_addresses.csv")
ca_addresses %>%
kable() %>%
kable_styling() %>%
scroll_box(width = "100%", height = "400px")| name | address | lat | long |
|---|---|---|---|
| NA | NA | NA | NA |
| 411 Broadway Spirits and Ales | 745 Fulton St, Fresno, California, 93721, United States | 36.73134 | -119.7874 |
| 8one8 Brewing | 8953 De Soto Avenue, Los Angeles, California, 91304, United States | 34.23329 | -118.5886 |
| Abnormal Beer Company | 16990 Via Tazon, Ste 123, San Diego, California, 92127, United States | 33.02424 | -117.0854 |
| Absolution Brewing Company | 2878 Columbia St, Torrance, California, 90503, United States | 33.84410 | -118.3380 |
| NA | 1795 Hancock St, San Diego, California, 92110, United States | 32.74257 | -117.1847 |
| Alaro Craft Brewery | 2004 Capitol Ave, Sacramento, California, 95811, United States | 38.57328 | -121.4812 |
| Ale House Brewing Company | 4020 Colmery Ct, San Jose, California, 95118, United States | 37.26227 | -121.9000 |
| NA | 9990 AleSmith Ct, San Diego, California, 92126, United States | NA | NA |
| NA | 8680 Miralani Dr, San Diego, California, 92126, United States | 32.89589 | -117.1374 |
| All Season Brewing | 800 South La Brea Ave, Los Angeles, California, 90036, United States | 34.06045 | -118.3446 |
| All-American Brew Works | 5120 E La Palma Ave, Unit 103, Anaheim, California, 92807, United States | 33.85975 | -117.7968 |
| NA | 833 W Torrance Blvd, Torrance, California, 90502, United States | 33.84210 | -118.2888 |
| Amalgamation Brewing Company | 6585 North Santa Fe Avenue, Fresno, California, 93722, United States | 36.83284 | -119.8784 |
| Amplified Ale Works | 4150 MIssion Blvd, Ste 208, San Diego, California, 92109, United States | 32.79205 | -117.2542 |
| NA | 1705 Mariposa Street, San Francisco, California, 94107, United States | 37.76355 | -122.4006 |
| Angel City Brewing Company (A&S Brewing - Boston Beer Co.) | 216 S Alameda St, Los Angeles, California, 90013, United States | 34.04664 | -118.2380 |
| Antigua Brewing Company (USA) | 1009 Monterey St., San Luis Obispo, California, 93401, United States | 35.28183 | -120.6611 |
| Arts District Brewing | 828 Traction Ave, Los Angeles, California, 90013, United States | 34.04478 | -118.2352 |
| Ashuraya Beverage Company | 5320 Zelzah Ave, Los Angeles, California, 91316, United States | 34.16755 | -118.5220 |
| Ass Kisser Ales | 6040 Camp Bowie Blvd #64, San Jose, California, United States | NA | NA |
| Asylum Brewing (Anaheim, CA) | 2970 E. La Palma Ave, Suite D, Anaheim, California, 92608, United States | 33.84971 | -117.8625 |
| At Ease Brewing Company | 1825 I Street, Sacramento, California, 95811, United States | 38.57844 | -121.4817 |
| Ataraxia Aleworks | 7292 Opportunity Rd Ste C, San Diego, California, 92111, United States | 32.82541 | -117.1603 |
| Audio Graph Beer Co. | 1203 Olive St., Los Angeles, California, 90016, United States | 34.03940 | -118.2623 |
| Automatic Brewing Company (BLAH) | 3416 Adams Ave, San Diego, California, 92116, United States | 32.76340 | -117.1201 |
| Aztec Brewing Company | 2330 La Mirada Dr, Ste 300, Vista, California, 92081, United States | 33.15212 | -117.2317 |
| Back Street Brewery (Vista) | 15 Main St, Ste 100, Vista, California, 92084, United States | 33.20001 | -117.2451 |
| Backstreet Brewery | 1884 S Santa Cruz St, Anaheim, California, 92805, United States | 33.79991 | -117.8961 |
| Bagby Beer Company | 601 S Coast Hwy, Oceanside, California, 92054, United States | 33.19933 | -117.3825 |
| Balefire Brewing | 2-1517 E Cliff Dr, Santa Cruz, California, 95062, United States | 36.96458 | -122.0081 |
| Ballast Point Brewing Company (Kings & Convicts) | 5401 Linda Vista Rd Ste 406, San Diego, California, 92110, United States | 32.76743 | -117.1950 |
| Bang The Drum Brewery | 950 Orcutt Rd, San Luis Obispo, California, 93401, United States | 35.26143 | -120.6444 |
| Barebottle Brewing Company | 1525 Cortland Ave, San Francisco, California, 94110, United States | 37.73977 | -122.4093 |
| Barley & Sword Brewing Company | 3052 El Cajon Blvd Ste 102, San Diego, California, 92104, United States | 32.75536 | -117.1286 |
| Barrel and Stave Brewing Company | 2129 Industrial Ct, Vista, Vista, California, 92081, United States | 33.16901 | -117.2209 |
| Barrel Head Brewhouse | 1785 Fulton St, San Francisco, California, 94117, United States | 37.77578 | -122.4462 |
| Bartlett Hall | 242 O’Farrell St, San Francisco, California, 94102, United States | 37.78639 | -122.4087 |
| BattleMage Brewing Company | 2870 Scott Street #102, Vista, California, 92081, United States | NA | NA |
| Bay City Brewing | 3760 Hancock St, Ste A, San Diego, California, 92110, United States | 32.75841 | -117.2119 |
| Beach Chalet Brewery | 1000 Great Hwy, San Francisco, California, 94121, United States | 37.76829 | -122.5104 |
| Bear Roots Brewing Company | 1213 S Santa Fe Ave, Vista, California, 92083, United States | 33.18771 | -117.2255 |
| Belching Beaver | 980 Park Center Dr, Ste A, Vista, California, 92081, United States | 33.14344 | -117.2307 |
| Benny Boy Brewing | 1821 Daly St, Los Angeles, California, 90031, United States | 34.06472 | -118.2154 |
| Big Sexy Brewing Company | 5861 88th St #800, Sacramento, California, 95828, United States | 38.52145 | -121.3758 |
| Big Stump Brewing Company | 1716 L St, Sacramento, California, 95811, United States | 38.57543 | -121.4846 |
| Bison Brewing Company | 2598 Telegraph Avenue, Berkeley, California, 94708, United States | 37.86414 | -122.2588 |
| Bitter Brothers Brewing Company | 4170 Morena Blvd, San Diego, California, 92117, United States | 32.82668 | -117.2304 |
| NA | 544 Bryant St, San Francisco, California, 94107, United States | 37.78061 | -122.3968 |
| Black Plague Brewing | 2550 Jason Ct, Oceanside, California, 92056, United States | 33.21585 | -117.2660 |
| Blessed Brewing | 660 Clarion Court, San Luis Obispo, California, 93401, United States | 35.24433 | -120.6466 |
| Bonaventure Brewing Company | 404 S Figueroa St, #418a, Los Angeles, California, 90071, United States | 34.05340 | -118.2560 |
| Boomtown Brewery | 700 Jackson St, Los Angeles, California, 90012, United States | 34.05104 | -118.2333 |
| Booze Brothers Brewing | 2545 Progress St, Ste D, Vista, California, 92081, United States | 33.14585 | -117.2194 |
| Border X Brewing | 8684 Avenida de la Fuente, Ste 8, San Diego, California, 92154, United States | 32.55636 | -116.9580 |
| Bottle Logic Brewing | 1072 N Armando St, Anaheim, California, 92806, United States | 33.84926 | -117.8599 |
| Breakwater Brewing Company | 101 N Coast Hwy, Oceanside, California, 92054, United States | 33.19506 | -117.3789 |
| Brewery X | 3191 E La Palma Ave, Anaheim, California, 92806, United States | 33.85172 | -117.8552 |
| Brewheim | 1931 E Wright Cir, Anaheim, California, 92806, United States | 33.80527 | -117.8896 |
| Brix Factory | 2400 Mandela Pkwy, Oakland, California, 94607, United States | 37.81828 | -122.2890 |
| Broken Timbers Brewing Company | 2910 E La Palma Ave Suite D, Anaheim, California, 92806, United States | 33.84914 | -117.8649 |
| Brouwerij West | 110 E 22nd St, Warehouse 9, Los Angeles, California, 90731, United States | NA | NA |
| Bruery Terreux | 1174 N Grove St, Anaheim, California, 92806, United States | 33.86152 | -117.8433 |
| Buck Wild | 401 Jackson St, Oakland, California, 94607, United States | 37.79518 | -122.2696 |
| Buena Vista Brewing | 256 Potrero St, Santa Cruz, California, 95060, United States | 36.98059 | -122.0309 |
| Buzzrock Brewing Company | 21770 Del Amo Cir E, Torrance, California, 90501, United States | 33.82963 | -118.3468 |
| California Wild Ales | 4202 Sorrento Valley Blvd, San Diego, California, 92121, United States | 32.90372 | -117.2178 |
| Camino Brewing Company | 718 S. 1st Street, San Jose, California, 95113, United States | 37.32526 | -121.8824 |
| Cellador Ales | 16745 Schoenborn St, Los Angeles, California, 91343, United States | 34.22268 | -118.4980 |
| Cellarmaker Brewing Company | 1150 Howard St, San Francisco, California, 94103, United States | 37.77709 | -122.4106 |
| Central Coast Brewing | 1422 Monterey St, San Luis Obispo, California, 93420, United States | 35.28556 | -120.6555 |
| Cerveceria Calidad | Los Angeles, California, 90064, United States | NA | NA |
| Cerveceria Mundial | 30 S Los Angeles St #205, Los Angeles, California, 90014, United States | 34.05255 | -118.2417 |
| Cerveza XTECA | 1827 Logan Ave, Ste 3, San Diego, California, 92113, United States | 32.70226 | -117.1455 |
| Clandestine Brewing | 980 S. First St. Ste. B, San Jose, California, 95110, United States | 37.32147 | -121.8790 |
| Cooperage Brewing Company | 981 Airway Ct, Santa Rosa, California, 95403, United States | 38.47464 | -122.7369 |
| Copper Bar Kitchen & Microbrewery | 4092 18th St, San Francisco, California, 94114, United States | 37.76096 | -122.4348 |
| Cosmic Ales | 20316 Gramercy Pl, Torrance, California, 90501, United States | 33.84662 | -118.3131 |
| Crooked Goat Brewing | 120 Morris St #120, Sebastopol, California, 95472, United States | 38.40332 | -122.8193 |
| Cultivar Beer | 2379 Chestnut St, San Francisco, California, 94123, United States | 37.79997 | -122.4424 |
| DarkHeart Brewing | 4339 Auburn Blvd B, Sacramento, California, 95841, United States | 38.64532 | -121.3634 |
| Deft Brewing | 5328 Banks St, San Diego, California, 92110, United States | 32.76435 | -117.1994 |
| Device Brewing Company | 8166 14th Ave, Sacramento, California, 95826, United States | 38.53952 | -121.4052 |
| District 10 Brewing | 1195 Evans Avenue, San Francisco, California, 94214, United States | 37.73860 | -122.3809 |
| Division 23 Brewing | 7408 Trade St, San Diego, California, 92121, United States | 32.88874 | -117.1623 |
| Dogleg Brewing Company | 1347 Keystone Way, Suite A, Vista, California, 92081, United States | 33.13574 | -117.2334 |
| Dokkaebier | 1735 Polk St., San Francisco, California, 94109, United States | 37.79269 | -122.4212 |
| Dos Desperados Brewery | 1241 Linda Vista Dr, San Marcos, California, 92078, United States | 33.13744 | -117.1928 |
| DTSJ | 345 23rd St, San Jose, California, 95116, United States | 37.34179 | -121.8641 |
| Duck Foot Brewing Company | 8920 Kenamar Dr, Ste #210, San Diego, California, 92121, United States | 32.88531 | -117.1556 |
| E-40 | San Jose, California, 95112, United States | NA | NA |
| Eagle Rock Brewery | 3056 Roswell St, Los Angeles, California, 90065, United States | 34.11476 | -118.2440 |
| El Cid Brewing Company | 2911 El Cajon Blvd STE 2, San Diego, California, 92104, United States | 32.75526 | -117.1312 |
| Embolden Beer Company | 8655 Production Ave ste A, San Diego, California, 92121, United States | 32.88268 | -117.1658 |
| Enterprise Brewing | 1150 Howard St, San Francisco, California, 94103, United States | 37.77709 | -122.4106 |
| Eppig Brewing | 3052 El Cajon Blvd, Ste C, San Diego, California, 92104, United States | 32.75536 | -117.1286 |
| Fall Brewing Company | 4542 30th St, San Diego, California, 92116, United States | 32.75997 | -117.1303 |
| Fat Cat Beer Company | 828 Prospect St, Ste E, San Diego, California, 92037, United States | 32.84570 | -117.2765 |
| Ferrous Falcon | San Marcos, California, United States | NA | NA |
| Fieldwork Brewing Company | 1160 Sixth St, Berkeley, California, 94710, United States | 37.88157 | -122.3022 |
| Firemans Brew | 6433 Topanga Canyon Blvd # 189, Los Angeles, California, 91303, United States | 34.18742 | -118.6060 |
| Five Suits Brewing | 2575 Pioneer Ave, Ste 104, Vista, California, 92081, United States | 33.14726 | -117.2196 |
| Floodcraft Brewing Company | 777 The Alameda, San Jose, California, 95126, United States | 37.33188 | -121.9055 |
| Fogbelt Brewing Company | 1305 Cleveland Ave, Santa Rosa, California, 95401, United States | 38.44889 | -122.7266 |
| Fox Tale Fermentation Project | 30 E Santa Clara St Suite 120, San Jose, California, 95113, United States | 37.33641 | -121.8899 |
| Frogtown Brewery | 2931 Gilroy St, Los Angeles, California, 90039, United States | 34.10651 | -118.2515 |
| Full Circle Brewing Company | 712 FULTON ST, Fresno, California, 93721, United States | 36.73112 | -119.7870 |
| GearTooth Alewerks | 1635 S 7th Street, San Jose, California, 95112, United States | 37.31451 | -121.8659 |
| George Lopez Brewing Co. | 21770 Del Amo Cir E, Torrance, California, 90503, United States | 33.82963 | -118.3468 |
| NA | 2640 Union St, Oakland, California, 94607, United States | 37.81954 | -122.2848 |
| Gilman Brewing Company | 912 Gilman St, Berkeley, California, 94710, United States | 37.87954 | -122.2999 |
| GOAL. Brewing | 3052 El Cajon Blvd Suite 101, San Diego, California, 92104, United States | 32.75536 | -117.1286 |
| Gojo Brewing Co. | Oakland, California, United States | NA | NA |
| Golden Gate Brewing Company | 346 Santa Clara Avenue, Oakland, California, 94610, United States | 37.81473 | -122.2488 |
| Golden Road Brewing (AB InBev) | 5410 W San Fernando Rd, Los Angeles, California, 90039, United States | 34.15048 | -118.2745 |
| Gordon Biersch Brewing Company (Craftworks) | 357 E Taylor St, San Jose, California, 95112, United States | 37.35264 | -121.8929 |
| Gravity Heights | 9920 Pacific Heights Blvd, San Diego, California, 92121, United States | 32.89920 | -117.1889 |
| Green Flash Brewing Company (Tilray) | 6550 Mira Mesa Blvd, San Diego, California, 92121, United States | 32.90646 | -117.1781 |
| Groundswell Brewing Company | 6304 Riverdale St, San Diego, California, 92120, United States | 32.78955 | -117.0997 |
| H2OPS Sparkling Hop Water | 155 N. Riverview Drive. STE 100, Anaheim, California, 92808, United States | 33.86963 | -117.7413 |
| Half Door Brewing | 903 Island Ave, San Diego, California, 92101, United States | 32.71038 | -117.1564 |
| Hand-Brewed Beer | 9771 Variel Ave., Los Angeles, California, 91311, United States | 34.24765 | -118.5930 |
| Hapa’s Brewing Company | 460 Lincoln Ave, Ste. 90, San Jose, California, 95126, United States | 37.32000 | -121.9083 |
| Hard Frescos Brewing Company | 3645 Lawton Street, San Francisco, California, 94122, United States | 37.75680 | -122.5019 |
| Harland Brewing Company | 10115 Carroll Canyon Rd, San Diego, California, 92131, United States | 32.90394 | -117.1095 |
| Harmonic Brewing | 1050 26th St, San Francisco, California, 94107, United States | 37.75147 | -122.3901 |
| Helia Brewing Company | 1250 Keystone Way, Vista, California, 92081, United States | 33.13605 | -117.2313 |
| Hella Coastal | 420 3rd St, Oakland, California, 94607, United States | 37.79636 | -122.2747 |
| HenHouse Brewing Company | 322 Bellevue Ave, Santa Rosa, California, 95407, United States | 38.40179 | -122.7241 |
| Heritage Barbecue & Beer Co. | 2002 S Coast Highway, Oceanside, California, 92054, United States | NA | NA |
| HiDef Brewing Company | 1203 S. Olive St., Los Angeles, California, 90015, United States | 34.03940 | -118.2623 |
| Highland Park Brewery | 5127 York Blvd, Los Angeles, California, 90042, United States | 34.12101 | -118.2041 |
| Hillcrest Brewing Company | 1458 University Avenue, San Diego, California, 92103, United States | 32.74856 | -117.1504 |
| Hodad’s Brewing | 9726 Aero Dr, Ste. B, San Diego, California, 92123, United States | 32.80901 | -117.1184 |
| Hoi Polloi Brewing | 1763 Alcatraz Ave, Berkeley, California, 94703, United States | 37.84873 | -122.2723 |
| Homebound Brew Haus | 800 N Alameda St, Los Angeles, California, 90012, United States | 34.05659 | -118.2373 |
| Hop Oast Pub & Brewery | 2887 Bryant St, San Francisco, California, 94110, United States | 37.74864 | -122.4087 |
| HopMonk | 230 Petaluma Ave, Sebastopol, California, 95472, United States | 38.40157 | -122.8227 |
| Hopnonymous Brewing Company | 7705 Convoy Court, San Diego, California, 92111, United States | 32.83469 | -117.1543 |
| Hoppy Brewing Company | 1022 2nd St, Sacramento, California, 95814, United States | 38.58246 | -121.5045 |
| HopSaint Brewing Company | 5160 W 190th St, Torrance, California, 90503, United States | 33.85822 | -118.3679 |
| Horus Aged Ales | 4040 Calle Platino, Suite 120, Oceanside, California, 92056, United States | 33.20667 | -117.2926 |
| House Brewing Company | Rose Avenue, Los Angeles, California, 90409, United States | NA | NA |
| Humble Sea Brewing Company | 820 Swift St, Santa Cruz, California, 95060, United States | 36.95958 | -122.0491 |
| Hunters Point | 1195 Evans Ave, San Francisco, California, 94124, United States | 37.73860 | -122.3809 |
| Imperial Western Beer Company | 800 North Alameda St, Los Angeles, California, 90012, United States | 34.05659 | -118.2373 |
| Incinerati Brewing Company | 411 Broadway Street, Fresno, California, 93721, United States | 36.72756 | -119.7850 |
| Iron Ox Brewing Company | 3334 Industrial Dr, Santa Rosa, California, 95403, United States | 38.47425 | -122.7401 |
| Itza Brewing | 4652 Del Mar Ave, San Diego, California, 92107, United States | 32.73814 | -117.2494 |
| Jiant | Washington Blvd, Los Angeles, California, 5299, United States | NA | NA |
| JT Schmids Brewhouse & Eatery | 2610 East Katella Avenue, Anaheim, California, 92806, United States | 33.80597 | -117.8773 |
| Jupiter | 2181 Shattuck Ave., Berkeley, California, 94704, United States | 37.86963 | -122.2678 |
| K-Oz Restaurant & Brewery | 121 7th St, San Francisco, California, 94103, United States | 37.77849 | -122.4099 |
| Kairoa Brewing Company | 4601 Park Blvd, San Diego, California, 92116, United States | 32.76102 | -117.1462 |
| Karl Strauss Brewing Company | 5985 Santa Fe St, San Diego, California, 92109, United States | 32.83063 | -117.2321 |
| Ketch Brewing | 7889 Ostrow St, San Diego, California, 92111, United States | 32.81376 | -117.1554 |
| Kilowatt Brewing | 7576 Clairemont Mesa Blvd, San Diego, California, 92111, United States | 32.83276 | -117.1566 |
| King Cong Brewing Company | 1709 Del Paso Blvd, Sacramento, California, 95815, United States | 38.60768 | -121.4560 |
| Kings & Convicts Miramar | 9550 Distribution Ave, San Diego, California, 92121, United States | 32.88005 | -117.1628 |
| Knotty Brewing | 842 Market St, San Diego, California, 921011, United States | 32.71157 | -117.1570 |
| NA | 256 Potrero St, Santa Cruz, California, 95060, United States | 36.98059 | -122.0309 |
| Latchkey Brewing | 2120 W Washington St, San Diego, California, 92110, United States | 32.74189 | -117.1834 |
| Latitude 33 Brewing Company | 1430 Vantage Ct, Ste 104, Vista, California, 92081, United States | 33.13716 | -117.2245 |
| NA | 1439 Egbert Ave, Unit A, San Francisco, California, 94124, United States | 37.72311 | -122.3935 |
| Lawless Brewing Co. | 5275 Craner Avenue, Los Angeles, California, 91601, United States | 34.16717 | -118.3692 |
| Lazy Duck Brewing Company | 1723 Rogers Ave Suite E, San Jose, California, 95112, United States | 37.37528 | -121.9088 |
| Line 51 Brewing | Oakland, California, 94607, United States | NA | NA |
| Little Miss Brewing | 7949 Stromesa Ct, Ste Y, San Diego, California, 92126, United States | 32.89257 | -117.1475 |
| Local Brewing Company | 69 Bluxome St, San Francisco, California, 94107, United States | 37.77645 | -122.3972 |
| Lost Marbles | 823 Clement St, San Francisco, California, 94118, United States | 37.78273 | -122.4679 |
| Lucky Devil Brewing Company | 2530 E 11th St, Oakland, California, 94601-1425, United States | 37.78007 | -122.2362 |
| MacLeod Ale Brewing Company | 14741 Calvert St, Los Angeles, California, 91411, United States | 34.18171 | -118.4540 |
| NA | 3085 E Campus Pointe Drive, Fresno, California, 93727, United States | NA | NA |
| Magnolia Brewing | 1398 Haight St, San Francisco, California, 94117, United States | 37.77028 | -122.4453 |
| Mason Ale Works | 255 Redel Rd, Ste 4347, San Marcos, California, 92078, United States | 33.13521 | -117.1589 |
| MateVeza Brewing Company | 26A Glover Street, San Francisco, California, 94109, United States | 37.79729 | -122.4157 |
| Mike Hess Brewing Company | 7955 Silverton Ave, Ste 1201, San Diego, California, 92126, United States | 32.89083 | -117.1518 |
| Mission Brewery | 1441 L St, San Diego, California, 92101, United States | NA | NA |
| Modern Times Beer | 3725 Greenwood St, San Diego, California, 92110, United States | 32.75412 | -117.2065 |
| Monkish Brewing Company | 20311 S Western Ave, Torrance, California, 90501, United States | 33.84666 | -118.3094 |
| Moonlight Brewing Company | 3350 Coffey Ln, Santa Rosa, California, 95403, United States | 38.47158 | -122.7458 |
| NA | 2055 Thibodo Rd, Ste H, Vista, California, 92081, United States | 33.16838 | -117.2202 |
| Mujeres Brew House | 1983 Julian Avenue, San Diego, California, 92113, United States | 32.70212 | -117.1414 |
| My Yard Live | 288 Rancheros Dr, San Marcos, California, 92069, United States | 33.13823 | -117.1588 |
| Nakhon Brewing Company | 246 N. Ave Twenty Five, Los Angeles, California, 90031, United States | 34.07861 | -118.2185 |
| Narrative Fermentations | 101 E Alma Ave, San Jose, California, 95112, United States | 37.31655 | -121.8738 |
| NA | 832 S Olive St, Los Angeles, California, 90014, United States | 34.04464 | -118.2573 |
| New Bohemia Brewing Company | 1030 41st. Avenue, Santa Cruz, California, 95062, United States | 36.96678 | -121.9648 |
| New English Brewing | 11545 Sorrento Valley Rd, Ste 305, San Diego, California, 92121, United States | 32.91211 | -117.2317 |
| New Glory Craft Brewery | 8251 Alpine Ave, Sacramento, California, 95826, United States | 38.53560 | -121.4021 |
| NA | 1730 Broadway, Sacramento, California, 95818, United States | 38.56099 | -121.4903 |
| Night Parade Brewing Co | 9879 Hibert Street Suite F, San Diego, California, 92131, United States | 32.91377 | -117.1130 |
| Noble Ale Works | 1621 S Sinclair St, Anaheim, California, 92806, United States | 33.80856 | -117.8822 |
| Noble Brewer | 4721 Tidewater Ave, Ste C, Oakland, California, 94601, United States | 37.76368 | -122.2215 |
| North Park Beer Company | 3038 University Ave, San Diego, California, 92104, United States | 32.74851 | -117.1287 |
| Northern Pine Brewing | 326 N Horne St, Oceanside, California, 92054, United States | 33.19929 | -117.3766 |
| NA | 181 Tank Farm Road Suite 110, San Luis Obispo, California, 93401, United States | 35.24675 | -120.6694 |
| Oak Park Brewing Company | 3514 Broadway, Sacramento, California, 95818, United States | 38.55133 | -121.4684 |
| Oakland Brewing Company | 1010 22nd Ave, Oakland, California, 94606, United States | 37.78192 | -122.2406 |
| Oakland United Beerworks | 3775 Alameda Ave, Unit G, Oakland, California, 94601, United States | 37.76806 | -122.2233 |
| OB Brewery | 5041 Newport Ave, San Diego, California, 92107, United States | 32.74712 | -117.2516 |
| Ocean Beach Brewery | 5041 Newport Avenue, San Diego, California, 92107, United States | 32.74712 | -117.2516 |
| Oceanside Ale Works | 1800 Ord Way, Oceanside, California, 92056, United States | 33.21038 | -117.2781 |
| Ohana Brewing Company | 1756 E 23rd St, Los Angeles, California, 90058, United States | 34.01578 | -118.2415 |
| Old Possum Brewing Company | 8138, 357 Sutton Pl, Santa Rosa, California, 95405, United States | 38.39095 | -122.7252 |
| Olde Ritual Brewing Company | 1409 R Street, Sacramento, California, 95811, United States | 38.57000 | -121.4915 |
| Olfactory Brewery & Blendery | 2245 3rd St, San Francisco, California, 94107, United States | 37.76121 | -122.3884 |
| Onibi Beer Company | Sacramento, California, United States | NA | NA |
| Original Pattern Brewing Company | 292 4th St, Oakland, California, 94607, United States | 37.79606 | -122.2718 |
| Otherwise Brewing | 1195 Evans Ave, San Francisco, California, United States | 37.73860 | -122.3809 |
| Owl Farm Unique Fermentations | 2545 Progress St, Vista, California, 92081, United States | 33.14585 | -117.2194 |
| Pacific Beach Ale House | 721 Grand Ave, San Diego, California, 92109, United States | 32.79441 | -117.2559 |
| Pacific Drift Brewing Company | 1441 L St, San Diego, California, 92101, United States | NA | NA |
| Palmia Corp. | San Francisco, California, United States | NA | NA |
| Party Beer Company | 4203 W JEFFERSON BLVD, Los Angeles, California, 90016, United States | 34.02561 | -118.3418 |
| People’s Republic of South Central | 1000 E 60th Street, Los Angeles, California, 90001, United States | 33.98563 | -118.2587 |
| Pete’s Restaurant & Brewhouse | 2001 J St, Sacramento, California, 95814, United States | 38.57673 | -121.4798 |
| Phantom Ales | 1211 N Las Brisas St, Anaheim, California, 92806, United States | 33.85404 | -117.8665 |
| Pine & Palm Brewing | 352 W Bedford Ave. STE 111, Fresno, California, 93711, United States | 36.84591 | -119.7975 |
| Pine Street Brewery | 761 Pine St, San Francisco, California, 94018, United States | 37.79110 | -122.4084 |
| Piston Pete’s Brewery & Distillery | 1084 La Mirada Ct, Vista, California, 92081, United States | NA | NA |
| Pizza Port (Ocean Beach) | 1956 Bacon St., San Diego, California, 92107, United States | 32.74813 | -117.2500 |
| Poor House Brewing Company | 4494 30th St, San Diego, California, 92116, United States | 32.75903 | -117.1302 |
| Porchlight Brewing Company | 866 57th St, Sacramento, California, 95819, United States | 38.56609 | -121.4333 |
| Port Brewing Company / The Lost Abbey | 155 Mata Way, Ste 104, San Marcos, California, 92069, United States | 33.14062 | -117.1498 |
| Private Press Brewing | 332 Ingalls St., Santa Cruz, California, 95060, United States | 36.95889 | -122.0464 |
| Procreations Brewing Company | 1929 Santa Clara Street, Fresno, California, 93721, United States | 36.72850 | -119.7854 |
| NA | 2004 E. Vista Way, Vista, California, 92084, United States | 33.23077 | -117.2262 |
| Protector Brewery | 8680 Miralani Dr #128, San Diego, California, 92126, United States | 32.89589 | -117.1374 |
| Puesto Cerveceria | 5010 Mission Center Rd, San Diego, California, 92108, United States | 32.76705 | -117.1535 |
| Pure Project | 9030 Kenamar Dr, Ste. 308, San Diego, California, 92121, United States | 32.88827 | -117.1555 |
| Quantum Brewing (CA) | 5375 Kearny Villa Rd, #116, San Diego, California, 92123, United States | 32.83112 | -117.1391 |
| Rad Beer Company | 1301 South Lewis St, Anaheim, California, 92805, United States | 33.81655 | -117.8980 |
| Radiant Beer Company | 1566 W Lincoln Ave, Anaheim, California, 92801, United States | 33.83956 | -117.8960 |
| RationAle Brewing | San Diego, California, United States | NA | NA |
| Red Car Brewery & Restaurant | 1266 Sartori Ave, Torrance, California, 90501, United States | 33.83610 | -118.3167 |
| Reel Brewery | Los Angeles, California, United States | NA | NA |
| Resident Brewing | 411 C St, San Diego, California, 92101, United States | 32.71670 | -117.1609 |
| Roses’ Brewing Company | 4930 Telegraph Ave, Oakland, California, 94609, United States | 37.83618 | -122.2625 |
| Rough Draft Brewing Company | 8830 Rehco Rd, Ste D, San Diego, California, 92121, United States | 32.88409 | -117.1711 |
| Ruhstaller Brewery | 726 K St, Sacramento, California, 95814, United States | 38.58007 | -121.4974 |
| Russian River Brewing Company | 725 4th St., Santa Rosa, California, 95404, United States | 38.44145 | -122.7120 |
| S27 Alehouse and Brewery | 461 Perrymont Ave, San Jose, California, 95125, United States | 37.29879 | -121.8721 |
| NA | 1616 J St, Sacramento, California, 95814, United States | 38.57798 | -121.4850 |
| Saint Archer Brewing Company (Tenth & Blake - Molson Coors) | 9550 Distrubution Ave, San Diego, California, 92121, United States | 32.88005 | -117.1628 |
| San Diego Brewing Company | 10450 Friars Rd, San Diego, California, 92120, United States | 32.79107 | -117.0987 |
| NA | 1405 Franklin St, Ste 102, San Francisco, California, 94109, United States | 37.78740 | -122.4235 |
| NA | 402 Ingalls St, Santa Cruz, California, 95060, United States | 36.95871 | -122.0475 |
| Santa Maria Brewing Company San Luis Obispo | 675 Clarion Ct, San Luis Obispo, California, 93401, United States | 35.24422 | -120.6460 |
| Scholb Premium Ales | 2964 Columbia Street, Torrance, California, 90503, United States | 33.84410 | -118.3395 |
| Seabright Brewery | 519 Seabright Ave, Santa Cruz, California, 95062, United States | 36.96758 | -122.0079 |
| Second Chance Beer Company | 15378 Avenue of Sciences, #222, San Diego, California, 92128, United States | 32.99445 | -117.0809 |
| NA | 3052 El Cajon Blvd. Ste C, San Diego, California, 92104, United States | 32.75536 | -117.1286 |
| Seismic Brewing Company | 2870 Duke Ct, Santa Rosa, California, 95407, United States | 38.40830 | -122.7224 |
| NA | 777 E Olive Ave, Fresno, California, 93728, United States | 36.75772 | -119.8020 |
| Shady Oak Barrel House | 420 1st Street, Santa Rosa, California, 95401, United States | 38.43709 | -122.7155 |
| Shanty Shack Brewing | 138 Fern Street, Santa Cruz, California, 95060, United States | 36.98597 | -122.0308 |
| Shapeshifters Cinema and Brewery | 567 5th St Oakland, CA, Oakland, California, 94607, United States | 37.79933 | -122.2783 |
| Shoots | 602 SOUTH TREMONT ST. STE 101, Oceanside, California, 92054, United States | 33.18913 | -117.3749 |
| Skyduster Beer | Los Angeles, California, United States | NA | NA |
| SLO Brew | 736 Higuera St, San Luis Obispo, California, 93401, United States | 35.27928 | -120.6640 |
| Smog City Brewing | 1901 Del Amo Blvd, Ste B, Torrance, California, 90501, United States | 33.84690 | -118.3133 |
| SoCal Beer Company | 18226 Ventura Blvd. Suite 208, Los Angeles, California, 91356, United States | 34.16624 | -118.5299 |
| Societe Brewing Company | 8262 Clairemont Mesa Blvd, San Diego, California, 92111, United States | 32.83284 | -117.1469 |
| South O Brewing | 1575 South Coast Highway, Oceanside, California, 92054, United States | 33.18000 | -117.3663 |
| Southern Pacific Brewing | 620 Treat Ave, San Francisco, California, 94110, United States | 37.76017 | -122.4138 |
| SouthNorte Beer Company | 1205 Knoxville St, San Diego, California, 92110, United States | 32.77200 | -117.2048 |
| NA | 1195 Evans Ave, San Francisco, California, 94124-1704, United States | 37.73860 | -122.3809 |
| Standard Deviant Brewing | 280 14th St, San Francisco, California, 94110, United States | 37.76835 | -122.4197 |
| Stave & Nail Brewing Company | 1325 Grand Ave, Ste 107, San Marcos, California, 92078, United States | 33.14310 | -117.1923 |
| Stone Brewing - Liberty Station (Sapporo) | 2816 Historic Decatur Rd, #116‎, San Diego, California, 92106, United States | 32.73976 | -117.2112 |
| Strike Brewing Company | 2099 S 10th St, Ste 30, San Jose, California, 95112, United States | 37.31051 | -121.8570 |
| Stumblefoot Brewing Company | 1784 La Costa Meadows Dr #103, San Marcos, California, 92078, United States | 33.10423 | -117.2196 |
| Sufferfest Beer Company (Sierra Nevada) | 2147 Greenwich Street, San Francisco, California, 94123, United States | 37.79900 | -122.4350 |
| Summer Fox | 6585 N Santa Fe Ave, Fresno, California, 93722, United States | 36.83284 | -119.8784 |
| Sunny Bev | 610 VENEZIA AVENUE SUITE A, Los Angeles, California, 90291, United States | 33.98976 | -118.4595 |
| Sunset Reservoir Brewing Company | 1735 Noriega St, San Francisco, California, 94122, United States | 37.75393 | -122.4823 |
| TapRoom Beer Co | 2000 El Cajon Blvd, San Diego, California, 92104, United States | 32.75531 | -117.1437 |
| NA | 4115 Telegraph Ave, Oakland, California, 94609, United States | 37.83015 | -122.2644 |
| Tenma Beer Project | 6510 San Pablo Ave, Oakland, California, 94608, United States | NA | NA |
| The Barn Brewery | 2850 El Cajon Blvd, Ste 3, San Diego, California, 92104, United States | 32.75536 | -117.1326 |
| The Bell Marker Brewery & Kitchen | 602 Broadway, San Diego, California, 92101, United States | 32.71576 | -117.1592 |
| The Dudes | 1840 W 208th St, Torrance, California, 90501, United States | 33.84181 | -118.3108 |
| The Gentleman Scholar | 2285 Westwood Boulevard, Los Angeles, California, 90064, United States | 34.04261 | -118.4307 |
| The Hop Concept | 155 Mata Way #104, San Marcos, California, 92069, United States | 33.14062 | -117.1498 |
| The Original 40 Brewing Company | 3117 University Ave, San Diego, California, 92104, United States | 32.74841 | -117.1267 |
| The Rare Barrel (Cellarmaker) | 940 Parker St, Berkeley, California, 94710, United States | 37.85867 | -122.2921 |
| There Does Not Exist | 4070 Earthwood Ln. Suite 110, San Luis Obispo, California, 93401, United States | NA | NA |
| Third Street Aleworks | 610 3rd St, Santa Rosa, California, 95404, United States | 38.43970 | -122.7132 |
| Thorn Brewing / Thorn Street Brewery | 3174 Thorn St, San Diego, California, 92104, United States | 32.73932 | -117.1255 |
| Tilt Brewing Company | Highlights info row image 357 E Taylor Street, San Jose, California, 95112, United States | 37.35264 | -121.8929 |
| Tiny Bubbles Brewing Company | 155 Mata Way #104, San Marcos, California, 92069, United States | 33.14062 | -117.1498 |
| Tioga-Sequoia Brewing Company | 746 Broadway St, Fresno, California, 93721, United States | 36.73070 | -119.7883 |
| Touchstone Brewing | 116 N 16th Street, Sacramento, California, 95811, United States | 38.58916 | -121.4805 |
| Towne Park Brew | 1566 W Lincoln Ave, Anaheim, California, 92801, United States | 33.83956 | -117.8960 |
| Track 7 Brewing Company | 3747 W Pacific Ave, Ste F, Sacramento, California, 95820, United States | 38.53970 | -121.4821 |
| Triple Rock Brewery & Alehouse | 1920 Shattuck Ave, Berkeley, California, 94704, United States | 37.87338 | -122.2687 |
| Triple Voodoo Brewing | 3145 Geary Blvd, Suite 410, San Francisco, California, 94118-3316, United States | 37.78170 | -122.4526 |
| Trumer Brauerei (US) | Berkeley, California, United States | NA | NA |
| Two Pitchers Brewing Company | San Francisco, California, United States | NA | NA |
| Two Roots Brewing Company | 4896 Newport Ave, San Diego, California, 92107, United States | 32.74578 | -117.2492 |
| Umunhum Brewing Co-Op | San Jose, California, United States | NA | NA |
| United Brands Company | 10940 Wilshire Boulevard, Suite 1600, Los Angeles, California, 90024, United States | 34.05831 | -118.4454 |
| Unreal Brewing | San Jose, California, United States | NA | NA |
| Uproar Brewing Company | 439 S. First Street, San Jose, California, 95113, United States | 37.32942 | -121.8856 |
| Urban Roots Brewing & Smokehouse | 1322 V St, Sacramento, California, 95818, United States | 38.56583 | -121.4946 |
| Venice Ale House | 2 Rose Ave, Los Angeles, California, 90291, United States | 33.99461 | -118.4804 |
| Venice Beach Beer Company | 642 Rose Ave, Los Angeles, California, 90291, United States | 33.99979 | -118.4707 |
| Venice Duck Brewery | 4238 Coolidge Ave, Los Angeles, California, 90055, United States | 34.00149 | -118.4177 |
| Wavelength Brewing Company | 236 Main St, Vista, California, 92084, United States | 33.20254 | -117.2419 |
| Weed Cellars | 927 N La Cienega Blvd, Los Angeles, California, 90069, United States | 34.08773 | -118.3765 |
| WestBrew | 1061 La Mirada Ct., Vista, California, 92081, United States | NA | NA |
| Western Standard Brewing Company | San Diego, California, United States | NA | NA |
| White Labs | 9495 Candida Street, San Diego, California, 92126, United States | 32.89619 | -117.1218 |
| Wiretap Brewing | 341 S Ave 17, Ste B, Los Angeles, California, 90031, United States | 34.06855 | -118.2220 |
| Woodfour Brewing Company | 6780 Depot St, #160, Sebastopol, California, 95472, United States | 38.40288 | -122.8221 |
| Woodhouse Blending and Brewing | 119 Madrone St, Santa Cruz, California, 95060, United States | 36.98282 | -122.0299 |
| Woods Beer & Wine | 1701 Telegraph Ave, Oakland, California, 94612, United States | 37.80691 | -122.2704 |
| Yorkshire Square Brewery | 1109 Van Ness Ave, Torrance, California, 90501, United States | 33.83726 | -118.3164 |
| Bivouac Ciderworks | 3986 30th St, San Diego, California, 92104, United States | 32.75006 | -117.1302 |
| Bonny Doon Vineyard | 328 Ingalls Street, Santa Cruz, California, 95060, United States | 36.95890 | -122.0463 |
| Brooks Cider | San Francisco, California, United States | NA | NA |
| California Cider Company | 2064 Gravenstein Hwy N, Building 4, Sebastopol, California, 95472, United States | 38.38034 | -122.8020 |
| Castellum Ciders | 1745 National Avenue, San Diego, California, 92113, United States | 32.70241 | -117.1477 |
| NA | 477 25th Street, Oakland, California, 94612, United States | 37.81446 | -122.2674 |
| Devoto Orchards | 655 Gold Ridge Road, Sebastopol, California, 95472, United States | 38.38911 | -122.8652 |
| Domaine Le Mieux / See Canyon Cider | 2885 See Canyon Road, San Luis Obispo, California, 93405, United States | 35.22466 | -120.7332 |
| Ethic Ciders | 8490 Occidental Road, Sebastopol, California, 95472, United States | 38.42503 | -122.8573 |
| FoxCraft Hard Cider Company | 409 Mendocino Ave, Santa Rosa, California, 95401, United States | 38.44121 | -122.7146 |
| Golden State Cider | Sebastopol, California, 95472, United States | NA | NA |
| Guthrie CiderWorks | 6496 Marindustry Dr, Ste D, San Diego, California, 92121, United States | 32.88131 | -117.1771 |
| Horse & Plow | 1272 Gravenstein Hwy N, Sebastopol, California, 95472, United States | 38.41339 | -122.8437 |
| Horse and Plow | 1272 Gravenstein Hwy N, Sebastopol, California, 95472, United States | 38.41339 | -122.8437 |
| Moonland Wines | Berkeley, California, 94710, United States | NA | NA |
| NA | 787 Brannan Street, San Francisco, California, 94103, United States | 37.77325 | -122.4028 |
| NA | 10045 Carroll Canyon Rd, Ste A, San Diego, California, 92131, United States | 32.90350 | -117.1107 |
| Raging Cider & Mead | 177 Newport Dr, Ste B, San Marcos, California, 92069, United States | 33.14342 | -117.1881 |
| Serpentine Cider | 8665 Miralani Dr, #100, San Diego, California, 92126, United States | 32.89579 | -117.1376 |
| Shindig Cider | San Luis Obispo, California, 93401, United States | NA | NA |
| Sincere Cider | Oakland, California, United States | NA | NA |
| SLO Cider Co. | 3419 Roberto Ct Suite C, San Luis Obispo, California, 93401, United States | 35.25943 | -120.6443 |
| Sonoma Cider (Full Circle Brewing) | 712 FULTON ST, Fresno, California, 93721, United States | 36.73112 | -119.7870 |
| Specific Gravity Cider Company | 708 Gravenstein Hwy North #174, Sebastopol, California, 95472, United States | 38.40855 | -122.8397 |
| Sutton Cellars | 601 22nd Street, San Francisco, California, 94107, United States | 37.75794 | -122.3874 |
| Tag + Jug Cider Company | 995 9th St, San Francisco, California, 94130, United States | 37.82540 | -122.3700 |
| Thomas Brothers Hard Cider Company | 2323 Fourth St, Ste. B, Berkeley, California, 94710, United States | 37.86267 | -122.2982 |
| Twin Hills Hard Cider | 1689 Pleasant Hill Rd, Sebastopol, California, 95472-4916, United States | 38.37907 | -122.8331 |
| Two Broads Ciderworks | 3427 Roberto Court Suite 130, San Luis Obispo, California, 93401, United States | 35.25939 | -120.6443 |
| Two Rivers Cider Company | 4311 Attawa Ave, Sacramento, California, 95882, United States | 38.53593 | -121.4845 |
| Bronto Mead | 9235 Trade Pl, Ste D, San Diego, California, 92126, United States | 32.89200 | -117.1533 |
| Enat Tej Winery | 910 81st Ave Ste 1, Oakland, California, 94621, United States | NA | NA |
| NA | 4093 Oceanside Blvd, Ste G, Oceanside, California, 92056, United States | 33.20625 | -117.2881 |
| Honey Pot Meadery | 5120 E. La Palma #104, Anaheim, California, 92807, United States | 33.85975 | -117.7968 |
| NA | 8665 Miralani Dr, Ste 100, San Diego, California, 92126, United States | 32.89579 | -117.1376 |
| Meadiocrity Mead | 1365 Grand Avenue, Suite 100, San Marcos, California, 92078, United States | 33.14340 | -117.1931 |
| NA | 901 Mission Street, Suite 105, San Francisco, California, 94103, United States | 37.78212 | -122.4072 |
| NA | 1042 La Mirada Ct, Vista, California, 92081, United States | NA | NA |
| Den Sake | 2311 Magnolia St, Oakland, California, 94607, United States | 37.81679 | -122.2848 |
| NA | 50 Apparel Way, San Francisco, California, 94124, United States | 37.74028 | -122.4028 |
| Setting Sun Sake | 8680 Miralani Dr, San Diego, California, 92126, United States | 32.89589 | -117.1374 |
| Takara Sake USA | 708 Addison St, Berkeley, California, 94710, United States | 37.86611 | -122.3001 |
ca_addresses %>%
filter(is.na(long) | is.na(lat)) %>%
kable() %>%
kable_styling() %>%
scroll_box(width = "100%", height = "400px")| name | address | lat | long |
|---|---|---|---|
| NA | NA | NA | NA |
| NA | 9990 AleSmith Ct, San Diego, California, 92126, United States | NA | NA |
| Ass Kisser Ales | 6040 Camp Bowie Blvd #64, San Jose, California, United States | NA | NA |
| BattleMage Brewing Company | 2870 Scott Street #102, Vista, California, 92081, United States | NA | NA |
| Brouwerij West | 110 E 22nd St, Warehouse 9, Los Angeles, California, 90731, United States | NA | NA |
| Cerveceria Calidad | Los Angeles, California, 90064, United States | NA | NA |
| E-40 | San Jose, California, 95112, United States | NA | NA |
| Ferrous Falcon | San Marcos, California, United States | NA | NA |
| Gojo Brewing Co. | Oakland, California, United States | NA | NA |
| Heritage Barbecue & Beer Co. | 2002 S Coast Highway, Oceanside, California, 92054, United States | NA | NA |
| House Brewing Company | Rose Avenue, Los Angeles, California, 90409, United States | NA | NA |
| Jiant | Washington Blvd, Los Angeles, California, 5299, United States | NA | NA |
| Line 51 Brewing | Oakland, California, 94607, United States | NA | NA |
| NA | 3085 E Campus Pointe Drive, Fresno, California, 93727, United States | NA | NA |
| Mission Brewery | 1441 L St, San Diego, California, 92101, United States | NA | NA |
| Onibi Beer Company | Sacramento, California, United States | NA | NA |
| Pacific Drift Brewing Company | 1441 L St, San Diego, California, 92101, United States | NA | NA |
| Palmia Corp. | San Francisco, California, United States | NA | NA |
| Piston Pete’s Brewery & Distillery | 1084 La Mirada Ct, Vista, California, 92081, United States | NA | NA |
| RationAle Brewing | San Diego, California, United States | NA | NA |
| Reel Brewery | Los Angeles, California, United States | NA | NA |
| Skyduster Beer | Los Angeles, California, United States | NA | NA |
| Tenma Beer Project | 6510 San Pablo Ave, Oakland, California, 94608, United States | NA | NA |
| There Does Not Exist | 4070 Earthwood Ln. Suite 110, San Luis Obispo, California, 93401, United States | NA | NA |
| Trumer Brauerei (US) | Berkeley, California, United States | NA | NA |
| Two Pitchers Brewing Company | San Francisco, California, United States | NA | NA |
| Umunhum Brewing Co-Op | San Jose, California, United States | NA | NA |
| Unreal Brewing | San Jose, California, United States | NA | NA |
| WestBrew | 1061 La Mirada Ct., Vista, California, 92081, United States | NA | NA |
| Western Standard Brewing Company | San Diego, California, United States | NA | NA |
| Brooks Cider | San Francisco, California, United States | NA | NA |
| Golden State Cider | Sebastopol, California, 95472, United States | NA | NA |
| Moonland Wines | Berkeley, California, 94710, United States | NA | NA |
| Shindig Cider | San Luis Obispo, California, 93401, United States | NA | NA |
| Sincere Cider | Oakland, California, United States | NA | NA |
| Enat Tej Winery | 910 81st Ave Ste 1, Oakland, California, 94621, United States | NA | NA |
| NA | 1042 La Mirada Ct, Vista, California, 92081, United States | NA | NA |
write.csv(na.omit(ca_addresses), "/home/ballengerb@ad.wlu.edu/BUS_317_01/wolffa24/Data/ca_addresses_cleaned.csv", row.names = FALSE)ca_addresses_cleaned <- read_csv("/home/ballengerb@ad.wlu.edu/BUS_317_01/wolffa24/Data/ca_addresses_cleaned.csv")
ca_addresses_cleaned %>%
kable() %>%
kable_styling() %>%
scroll_box(width = "100%", height = "400px")| name | address | lat | long |
|---|---|---|---|
| 411 Broadway Spirits and Ales | 745 Fulton St, Fresno, California, 93721, United States | 36.73134 | -119.7874 |
| 8one8 Brewing | 8953 De Soto Avenue, Los Angeles, California, 91304, United States | 34.23329 | -118.5886 |
| Abnormal Beer Company | 16990 Via Tazon, Ste 123, San Diego, California, 92127, United States | 33.02424 | -117.0854 |
| Absolution Brewing Company | 2878 Columbia St, Torrance, California, 90503, United States | 33.84410 | -118.3380 |
| Alaro Craft Brewery | 2004 Capitol Ave, Sacramento, California, 95811, United States | 38.57328 | -121.4812 |
| Ale House Brewing Company | 4020 Colmery Ct, San Jose, California, 95118, United States | 37.26227 | -121.9000 |
| All Season Brewing | 800 South La Brea Ave, Los Angeles, California, 90036, United States | 34.06045 | -118.3446 |
| All-American Brew Works | 5120 E La Palma Ave, Unit 103, Anaheim, California, 92807, United States | 33.85975 | -117.7968 |
| Amalgamation Brewing Company | 6585 North Santa Fe Avenue, Fresno, California, 93722, United States | 36.83284 | -119.8784 |
| Amplified Ale Works | 4150 MIssion Blvd, Ste 208, San Diego, California, 92109, United States | 32.79205 | -117.2542 |
| Angel City Brewing Company (A&S Brewing - Boston Beer Co.) | 216 S Alameda St, Los Angeles, California, 90013, United States | 34.04664 | -118.2380 |
| Antigua Brewing Company (USA) | 1009 Monterey St., San Luis Obispo, California, 93401, United States | 35.28183 | -120.6611 |
| Arts District Brewing | 828 Traction Ave, Los Angeles, California, 90013, United States | 34.04478 | -118.2352 |
| Ashuraya Beverage Company | 5320 Zelzah Ave, Los Angeles, California, 91316, United States | 34.16755 | -118.5220 |
| Asylum Brewing (Anaheim, CA) | 2970 E. La Palma Ave, Suite D, Anaheim, California, 92608, United States | 33.84971 | -117.8625 |
| At Ease Brewing Company | 1825 I Street, Sacramento, California, 95811, United States | 38.57844 | -121.4817 |
| Ataraxia Aleworks | 7292 Opportunity Rd Ste C, San Diego, California, 92111, United States | 32.82541 | -117.1603 |
| Audio Graph Beer Co. | 1203 Olive St., Los Angeles, California, 90016, United States | 34.03940 | -118.2623 |
| Automatic Brewing Company (BLAH) | 3416 Adams Ave, San Diego, California, 92116, United States | 32.76340 | -117.1201 |
| Aztec Brewing Company | 2330 La Mirada Dr, Ste 300, Vista, California, 92081, United States | 33.15212 | -117.2317 |
| Back Street Brewery (Vista) | 15 Main St, Ste 100, Vista, California, 92084, United States | 33.20001 | -117.2451 |
| Backstreet Brewery | 1884 S Santa Cruz St, Anaheim, California, 92805, United States | 33.79991 | -117.8961 |
| Bagby Beer Company | 601 S Coast Hwy, Oceanside, California, 92054, United States | 33.19933 | -117.3825 |
| Balefire Brewing | 2-1517 E Cliff Dr, Santa Cruz, California, 95062, United States | 36.96458 | -122.0081 |
| Ballast Point Brewing Company (Kings & Convicts) | 5401 Linda Vista Rd Ste 406, San Diego, California, 92110, United States | 32.76743 | -117.1950 |
| Bang The Drum Brewery | 950 Orcutt Rd, San Luis Obispo, California, 93401, United States | 35.26143 | -120.6444 |
| Barebottle Brewing Company | 1525 Cortland Ave, San Francisco, California, 94110, United States | 37.73977 | -122.4093 |
| Barley & Sword Brewing Company | 3052 El Cajon Blvd Ste 102, San Diego, California, 92104, United States | 32.75536 | -117.1286 |
| Barrel and Stave Brewing Company | 2129 Industrial Ct, Vista, Vista, California, 92081, United States | 33.16901 | -117.2209 |
| Barrel Head Brewhouse | 1785 Fulton St, San Francisco, California, 94117, United States | 37.77578 | -122.4462 |
| Bartlett Hall | 242 O’Farrell St, San Francisco, California, 94102, United States | 37.78639 | -122.4087 |
| Bay City Brewing | 3760 Hancock St, Ste A, San Diego, California, 92110, United States | 32.75841 | -117.2119 |
| Beach Chalet Brewery | 1000 Great Hwy, San Francisco, California, 94121, United States | 37.76829 | -122.5104 |
| Bear Roots Brewing Company | 1213 S Santa Fe Ave, Vista, California, 92083, United States | 33.18771 | -117.2255 |
| Belching Beaver | 980 Park Center Dr, Ste A, Vista, California, 92081, United States | 33.14344 | -117.2307 |
| Benny Boy Brewing | 1821 Daly St, Los Angeles, California, 90031, United States | 34.06472 | -118.2154 |
| Big Sexy Brewing Company | 5861 88th St #800, Sacramento, California, 95828, United States | 38.52145 | -121.3758 |
| Big Stump Brewing Company | 1716 L St, Sacramento, California, 95811, United States | 38.57543 | -121.4846 |
| Bison Brewing Company | 2598 Telegraph Avenue, Berkeley, California, 94708, United States | 37.86414 | -122.2588 |
| Bitter Brothers Brewing Company | 4170 Morena Blvd, San Diego, California, 92117, United States | 32.82668 | -117.2304 |
| Black Plague Brewing | 2550 Jason Ct, Oceanside, California, 92056, United States | 33.21585 | -117.2660 |
| Blessed Brewing | 660 Clarion Court, San Luis Obispo, California, 93401, United States | 35.24433 | -120.6466 |
| Bonaventure Brewing Company | 404 S Figueroa St, #418a, Los Angeles, California, 90071, United States | 34.05340 | -118.2560 |
| Boomtown Brewery | 700 Jackson St, Los Angeles, California, 90012, United States | 34.05104 | -118.2333 |
| Booze Brothers Brewing | 2545 Progress St, Ste D, Vista, California, 92081, United States | 33.14585 | -117.2194 |
| Border X Brewing | 8684 Avenida de la Fuente, Ste 8, San Diego, California, 92154, United States | 32.55636 | -116.9580 |
| Bottle Logic Brewing | 1072 N Armando St, Anaheim, California, 92806, United States | 33.84926 | -117.8599 |
| Breakwater Brewing Company | 101 N Coast Hwy, Oceanside, California, 92054, United States | 33.19506 | -117.3789 |
| Brewery X | 3191 E La Palma Ave, Anaheim, California, 92806, United States | 33.85172 | -117.8552 |
| Brewheim | 1931 E Wright Cir, Anaheim, California, 92806, United States | 33.80527 | -117.8896 |
| Brix Factory | 2400 Mandela Pkwy, Oakland, California, 94607, United States | 37.81828 | -122.2890 |
| Broken Timbers Brewing Company | 2910 E La Palma Ave Suite D, Anaheim, California, 92806, United States | 33.84914 | -117.8649 |
| Bruery Terreux | 1174 N Grove St, Anaheim, California, 92806, United States | 33.86152 | -117.8433 |
| Buck Wild | 401 Jackson St, Oakland, California, 94607, United States | 37.79518 | -122.2696 |
| Buena Vista Brewing | 256 Potrero St, Santa Cruz, California, 95060, United States | 36.98059 | -122.0309 |
| Buzzrock Brewing Company | 21770 Del Amo Cir E, Torrance, California, 90501, United States | 33.82963 | -118.3468 |
| California Wild Ales | 4202 Sorrento Valley Blvd, San Diego, California, 92121, United States | 32.90372 | -117.2178 |
| Camino Brewing Company | 718 S. 1st Street, San Jose, California, 95113, United States | 37.32526 | -121.8824 |
| Cellador Ales | 16745 Schoenborn St, Los Angeles, California, 91343, United States | 34.22268 | -118.4980 |
| Cellarmaker Brewing Company | 1150 Howard St, San Francisco, California, 94103, United States | 37.77709 | -122.4106 |
| Central Coast Brewing | 1422 Monterey St, San Luis Obispo, California, 93420, United States | 35.28556 | -120.6555 |
| Cerveceria Mundial | 30 S Los Angeles St #205, Los Angeles, California, 90014, United States | 34.05255 | -118.2417 |
| Cerveza XTECA | 1827 Logan Ave, Ste 3, San Diego, California, 92113, United States | 32.70226 | -117.1455 |
| Clandestine Brewing | 980 S. First St. Ste. B, San Jose, California, 95110, United States | 37.32147 | -121.8790 |
| Cooperage Brewing Company | 981 Airway Ct, Santa Rosa, California, 95403, United States | 38.47464 | -122.7369 |
| Copper Bar Kitchen & Microbrewery | 4092 18th St, San Francisco, California, 94114, United States | 37.76096 | -122.4348 |
| Cosmic Ales | 20316 Gramercy Pl, Torrance, California, 90501, United States | 33.84662 | -118.3131 |
| Crooked Goat Brewing | 120 Morris St #120, Sebastopol, California, 95472, United States | 38.40332 | -122.8193 |
| Cultivar Beer | 2379 Chestnut St, San Francisco, California, 94123, United States | 37.79997 | -122.4424 |
| DarkHeart Brewing | 4339 Auburn Blvd B, Sacramento, California, 95841, United States | 38.64532 | -121.3634 |
| Deft Brewing | 5328 Banks St, San Diego, California, 92110, United States | 32.76435 | -117.1994 |
| Device Brewing Company | 8166 14th Ave, Sacramento, California, 95826, United States | 38.53952 | -121.4052 |
| District 10 Brewing | 1195 Evans Avenue, San Francisco, California, 94214, United States | 37.73860 | -122.3809 |
| Division 23 Brewing | 7408 Trade St, San Diego, California, 92121, United States | 32.88874 | -117.1623 |
| Dogleg Brewing Company | 1347 Keystone Way, Suite A, Vista, California, 92081, United States | 33.13574 | -117.2334 |
| Dokkaebier | 1735 Polk St., San Francisco, California, 94109, United States | 37.79269 | -122.4212 |
| Dos Desperados Brewery | 1241 Linda Vista Dr, San Marcos, California, 92078, United States | 33.13744 | -117.1928 |
| DTSJ | 345 23rd St, San Jose, California, 95116, United States | 37.34179 | -121.8641 |
| Duck Foot Brewing Company | 8920 Kenamar Dr, Ste #210, San Diego, California, 92121, United States | 32.88531 | -117.1556 |
| Eagle Rock Brewery | 3056 Roswell St, Los Angeles, California, 90065, United States | 34.11476 | -118.2440 |
| El Cid Brewing Company | 2911 El Cajon Blvd STE 2, San Diego, California, 92104, United States | 32.75526 | -117.1312 |
| Embolden Beer Company | 8655 Production Ave ste A, San Diego, California, 92121, United States | 32.88268 | -117.1658 |
| Enterprise Brewing | 1150 Howard St, San Francisco, California, 94103, United States | 37.77709 | -122.4106 |
| Eppig Brewing | 3052 El Cajon Blvd, Ste C, San Diego, California, 92104, United States | 32.75536 | -117.1286 |
| Fall Brewing Company | 4542 30th St, San Diego, California, 92116, United States | 32.75997 | -117.1303 |
| Fat Cat Beer Company | 828 Prospect St, Ste E, San Diego, California, 92037, United States | 32.84570 | -117.2765 |
| Fieldwork Brewing Company | 1160 Sixth St, Berkeley, California, 94710, United States | 37.88157 | -122.3022 |
| Firemans Brew | 6433 Topanga Canyon Blvd # 189, Los Angeles, California, 91303, United States | 34.18742 | -118.6060 |
| Five Suits Brewing | 2575 Pioneer Ave, Ste 104, Vista, California, 92081, United States | 33.14726 | -117.2196 |
| Floodcraft Brewing Company | 777 The Alameda, San Jose, California, 95126, United States | 37.33188 | -121.9055 |
| Fogbelt Brewing Company | 1305 Cleveland Ave, Santa Rosa, California, 95401, United States | 38.44889 | -122.7266 |
| Fox Tale Fermentation Project | 30 E Santa Clara St Suite 120, San Jose, California, 95113, United States | 37.33641 | -121.8899 |
| Frogtown Brewery | 2931 Gilroy St, Los Angeles, California, 90039, United States | 34.10651 | -118.2515 |
| Full Circle Brewing Company | 712 FULTON ST, Fresno, California, 93721, United States | 36.73112 | -119.7870 |
| GearTooth Alewerks | 1635 S 7th Street, San Jose, California, 95112, United States | 37.31451 | -121.8659 |
| George Lopez Brewing Co. | 21770 Del Amo Cir E, Torrance, California, 90503, United States | 33.82963 | -118.3468 |
| Gilman Brewing Company | 912 Gilman St, Berkeley, California, 94710, United States | 37.87954 | -122.2999 |
| GOAL. Brewing | 3052 El Cajon Blvd Suite 101, San Diego, California, 92104, United States | 32.75536 | -117.1286 |
| Golden Gate Brewing Company | 346 Santa Clara Avenue, Oakland, California, 94610, United States | 37.81473 | -122.2488 |
| Golden Road Brewing (AB InBev) | 5410 W San Fernando Rd, Los Angeles, California, 90039, United States | 34.15048 | -118.2745 |
| Gordon Biersch Brewing Company (Craftworks) | 357 E Taylor St, San Jose, California, 95112, United States | 37.35264 | -121.8929 |
| Gravity Heights | 9920 Pacific Heights Blvd, San Diego, California, 92121, United States | 32.89920 | -117.1889 |
| Green Flash Brewing Company (Tilray) | 6550 Mira Mesa Blvd, San Diego, California, 92121, United States | 32.90646 | -117.1781 |
| Groundswell Brewing Company | 6304 Riverdale St, San Diego, California, 92120, United States | 32.78955 | -117.0997 |
| H2OPS Sparkling Hop Water | 155 N. Riverview Drive. STE 100, Anaheim, California, 92808, United States | 33.86963 | -117.7413 |
| Half Door Brewing | 903 Island Ave, San Diego, California, 92101, United States | 32.71038 | -117.1564 |
| Hand-Brewed Beer | 9771 Variel Ave., Los Angeles, California, 91311, United States | 34.24765 | -118.5930 |
| Hapa’s Brewing Company | 460 Lincoln Ave, Ste. 90, San Jose, California, 95126, United States | 37.32000 | -121.9083 |
| Hard Frescos Brewing Company | 3645 Lawton Street, San Francisco, California, 94122, United States | 37.75680 | -122.5019 |
| Harland Brewing Company | 10115 Carroll Canyon Rd, San Diego, California, 92131, United States | 32.90394 | -117.1095 |
| Harmonic Brewing | 1050 26th St, San Francisco, California, 94107, United States | 37.75147 | -122.3901 |
| Helia Brewing Company | 1250 Keystone Way, Vista, California, 92081, United States | 33.13605 | -117.2313 |
| Hella Coastal | 420 3rd St, Oakland, California, 94607, United States | 37.79636 | -122.2747 |
| HenHouse Brewing Company | 322 Bellevue Ave, Santa Rosa, California, 95407, United States | 38.40179 | -122.7241 |
| HiDef Brewing Company | 1203 S. Olive St., Los Angeles, California, 90015, United States | 34.03940 | -118.2623 |
| Highland Park Brewery | 5127 York Blvd, Los Angeles, California, 90042, United States | 34.12101 | -118.2041 |
| Hillcrest Brewing Company | 1458 University Avenue, San Diego, California, 92103, United States | 32.74856 | -117.1504 |
| Hodad’s Brewing | 9726 Aero Dr, Ste. B, San Diego, California, 92123, United States | 32.80901 | -117.1184 |
| Hoi Polloi Brewing | 1763 Alcatraz Ave, Berkeley, California, 94703, United States | 37.84873 | -122.2723 |
| Homebound Brew Haus | 800 N Alameda St, Los Angeles, California, 90012, United States | 34.05659 | -118.2373 |
| Hop Oast Pub & Brewery | 2887 Bryant St, San Francisco, California, 94110, United States | 37.74864 | -122.4087 |
| HopMonk | 230 Petaluma Ave, Sebastopol, California, 95472, United States | 38.40157 | -122.8227 |
| Hopnonymous Brewing Company | 7705 Convoy Court, San Diego, California, 92111, United States | 32.83469 | -117.1543 |
| Hoppy Brewing Company | 1022 2nd St, Sacramento, California, 95814, United States | 38.58246 | -121.5045 |
| HopSaint Brewing Company | 5160 W 190th St, Torrance, California, 90503, United States | 33.85822 | -118.3679 |
| Horus Aged Ales | 4040 Calle Platino, Suite 120, Oceanside, California, 92056, United States | 33.20667 | -117.2926 |
| Humble Sea Brewing Company | 820 Swift St, Santa Cruz, California, 95060, United States | 36.95958 | -122.0491 |
| Hunters Point | 1195 Evans Ave, San Francisco, California, 94124, United States | 37.73860 | -122.3809 |
| Imperial Western Beer Company | 800 North Alameda St, Los Angeles, California, 90012, United States | 34.05659 | -118.2373 |
| Incinerati Brewing Company | 411 Broadway Street, Fresno, California, 93721, United States | 36.72756 | -119.7850 |
| Iron Ox Brewing Company | 3334 Industrial Dr, Santa Rosa, California, 95403, United States | 38.47425 | -122.7401 |
| Itza Brewing | 4652 Del Mar Ave, San Diego, California, 92107, United States | 32.73814 | -117.2494 |
| JT Schmids Brewhouse & Eatery | 2610 East Katella Avenue, Anaheim, California, 92806, United States | 33.80597 | -117.8773 |
| Jupiter | 2181 Shattuck Ave., Berkeley, California, 94704, United States | 37.86963 | -122.2678 |
| K-Oz Restaurant & Brewery | 121 7th St, San Francisco, California, 94103, United States | 37.77849 | -122.4099 |
| Kairoa Brewing Company | 4601 Park Blvd, San Diego, California, 92116, United States | 32.76102 | -117.1462 |
| Karl Strauss Brewing Company | 5985 Santa Fe St, San Diego, California, 92109, United States | 32.83063 | -117.2321 |
| Ketch Brewing | 7889 Ostrow St, San Diego, California, 92111, United States | 32.81376 | -117.1554 |
| Kilowatt Brewing | 7576 Clairemont Mesa Blvd, San Diego, California, 92111, United States | 32.83276 | -117.1566 |
| King Cong Brewing Company | 1709 Del Paso Blvd, Sacramento, California, 95815, United States | 38.60768 | -121.4560 |
| Kings & Convicts Miramar | 9550 Distribution Ave, San Diego, California, 92121, United States | 32.88005 | -117.1628 |
| Knotty Brewing | 842 Market St, San Diego, California, 921011, United States | 32.71157 | -117.1570 |
| Latchkey Brewing | 2120 W Washington St, San Diego, California, 92110, United States | 32.74189 | -117.1834 |
| Latitude 33 Brewing Company | 1430 Vantage Ct, Ste 104, Vista, California, 92081, United States | 33.13716 | -117.2245 |
| Lawless Brewing Co. | 5275 Craner Avenue, Los Angeles, California, 91601, United States | 34.16717 | -118.3692 |
| Lazy Duck Brewing Company | 1723 Rogers Ave Suite E, San Jose, California, 95112, United States | 37.37528 | -121.9088 |
| Little Miss Brewing | 7949 Stromesa Ct, Ste Y, San Diego, California, 92126, United States | 32.89257 | -117.1475 |
| Local Brewing Company | 69 Bluxome St, San Francisco, California, 94107, United States | 37.77645 | -122.3972 |
| Lost Marbles | 823 Clement St, San Francisco, California, 94118, United States | 37.78273 | -122.4679 |
| Lucky Devil Brewing Company | 2530 E 11th St, Oakland, California, 94601-1425, United States | 37.78007 | -122.2362 |
| MacLeod Ale Brewing Company | 14741 Calvert St, Los Angeles, California, 91411, United States | 34.18171 | -118.4540 |
| Magnolia Brewing | 1398 Haight St, San Francisco, California, 94117, United States | 37.77028 | -122.4453 |
| Mason Ale Works | 255 Redel Rd, Ste 4347, San Marcos, California, 92078, United States | 33.13521 | -117.1589 |
| MateVeza Brewing Company | 26A Glover Street, San Francisco, California, 94109, United States | 37.79729 | -122.4157 |
| Mike Hess Brewing Company | 7955 Silverton Ave, Ste 1201, San Diego, California, 92126, United States | 32.89083 | -117.1518 |
| Modern Times Beer | 3725 Greenwood St, San Diego, California, 92110, United States | 32.75412 | -117.2065 |
| Monkish Brewing Company | 20311 S Western Ave, Torrance, California, 90501, United States | 33.84666 | -118.3094 |
| Moonlight Brewing Company | 3350 Coffey Ln, Santa Rosa, California, 95403, United States | 38.47158 | -122.7458 |
| Mujeres Brew House | 1983 Julian Avenue, San Diego, California, 92113, United States | 32.70212 | -117.1414 |
| My Yard Live | 288 Rancheros Dr, San Marcos, California, 92069, United States | 33.13823 | -117.1588 |
| Nakhon Brewing Company | 246 N. Ave Twenty Five, Los Angeles, California, 90031, United States | 34.07861 | -118.2185 |
| Narrative Fermentations | 101 E Alma Ave, San Jose, California, 95112, United States | 37.31655 | -121.8738 |
| New Bohemia Brewing Company | 1030 41st. Avenue, Santa Cruz, California, 95062, United States | 36.96678 | -121.9648 |
| New English Brewing | 11545 Sorrento Valley Rd, Ste 305, San Diego, California, 92121, United States | 32.91211 | -117.2317 |
| New Glory Craft Brewery | 8251 Alpine Ave, Sacramento, California, 95826, United States | 38.53560 | -121.4021 |
| Night Parade Brewing Co | 9879 Hibert Street Suite F, San Diego, California, 92131, United States | 32.91377 | -117.1130 |
| Noble Ale Works | 1621 S Sinclair St, Anaheim, California, 92806, United States | 33.80856 | -117.8822 |
| Noble Brewer | 4721 Tidewater Ave, Ste C, Oakland, California, 94601, United States | 37.76368 | -122.2215 |
| North Park Beer Company | 3038 University Ave, San Diego, California, 92104, United States | 32.74851 | -117.1287 |
| Northern Pine Brewing | 326 N Horne St, Oceanside, California, 92054, United States | 33.19929 | -117.3766 |
| Oak Park Brewing Company | 3514 Broadway, Sacramento, California, 95818, United States | 38.55133 | -121.4684 |
| Oakland Brewing Company | 1010 22nd Ave, Oakland, California, 94606, United States | 37.78192 | -122.2406 |
| Oakland United Beerworks | 3775 Alameda Ave, Unit G, Oakland, California, 94601, United States | 37.76806 | -122.2233 |
| OB Brewery | 5041 Newport Ave, San Diego, California, 92107, United States | 32.74712 | -117.2516 |
| Ocean Beach Brewery | 5041 Newport Avenue, San Diego, California, 92107, United States | 32.74712 | -117.2516 |
| Oceanside Ale Works | 1800 Ord Way, Oceanside, California, 92056, United States | 33.21038 | -117.2781 |
| Ohana Brewing Company | 1756 E 23rd St, Los Angeles, California, 90058, United States | 34.01578 | -118.2415 |
| Old Possum Brewing Company | 8138, 357 Sutton Pl, Santa Rosa, California, 95405, United States | 38.39095 | -122.7252 |
| Olde Ritual Brewing Company | 1409 R Street, Sacramento, California, 95811, United States | 38.57000 | -121.4915 |
| Olfactory Brewery & Blendery | 2245 3rd St, San Francisco, California, 94107, United States | 37.76121 | -122.3884 |
| Original Pattern Brewing Company | 292 4th St, Oakland, California, 94607, United States | 37.79606 | -122.2718 |
| Otherwise Brewing | 1195 Evans Ave, San Francisco, California, United States | 37.73860 | -122.3809 |
| Owl Farm Unique Fermentations | 2545 Progress St, Vista, California, 92081, United States | 33.14585 | -117.2194 |
| Pacific Beach Ale House | 721 Grand Ave, San Diego, California, 92109, United States | 32.79441 | -117.2559 |
| Party Beer Company | 4203 W JEFFERSON BLVD, Los Angeles, California, 90016, United States | 34.02561 | -118.3418 |
| People’s Republic of South Central | 1000 E 60th Street, Los Angeles, California, 90001, United States | 33.98563 | -118.2587 |
| Pete’s Restaurant & Brewhouse | 2001 J St, Sacramento, California, 95814, United States | 38.57673 | -121.4798 |
| Phantom Ales | 1211 N Las Brisas St, Anaheim, California, 92806, United States | 33.85404 | -117.8665 |
| Pine & Palm Brewing | 352 W Bedford Ave. STE 111, Fresno, California, 93711, United States | 36.84591 | -119.7975 |
| Pine Street Brewery | 761 Pine St, San Francisco, California, 94018, United States | 37.79110 | -122.4084 |
| Pizza Port (Ocean Beach) | 1956 Bacon St., San Diego, California, 92107, United States | 32.74813 | -117.2500 |
| Poor House Brewing Company | 4494 30th St, San Diego, California, 92116, United States | 32.75903 | -117.1302 |
| Porchlight Brewing Company | 866 57th St, Sacramento, California, 95819, United States | 38.56609 | -121.4333 |
| Port Brewing Company / The Lost Abbey | 155 Mata Way, Ste 104, San Marcos, California, 92069, United States | 33.14062 | -117.1498 |
| Private Press Brewing | 332 Ingalls St., Santa Cruz, California, 95060, United States | 36.95889 | -122.0464 |
| Procreations Brewing Company | 1929 Santa Clara Street, Fresno, California, 93721, United States | 36.72850 | -119.7854 |
| Protector Brewery | 8680 Miralani Dr #128, San Diego, California, 92126, United States | 32.89589 | -117.1374 |
| Puesto Cerveceria | 5010 Mission Center Rd, San Diego, California, 92108, United States | 32.76705 | -117.1535 |
| Pure Project | 9030 Kenamar Dr, Ste. 308, San Diego, California, 92121, United States | 32.88827 | -117.1555 |
| Quantum Brewing (CA) | 5375 Kearny Villa Rd, #116, San Diego, California, 92123, United States | 32.83112 | -117.1391 |
| Rad Beer Company | 1301 South Lewis St, Anaheim, California, 92805, United States | 33.81655 | -117.8980 |
| Radiant Beer Company | 1566 W Lincoln Ave, Anaheim, California, 92801, United States | 33.83956 | -117.8960 |
| Red Car Brewery & Restaurant | 1266 Sartori Ave, Torrance, California, 90501, United States | 33.83610 | -118.3167 |
| Resident Brewing | 411 C St, San Diego, California, 92101, United States | 32.71670 | -117.1609 |
| Roses’ Brewing Company | 4930 Telegraph Ave, Oakland, California, 94609, United States | 37.83618 | -122.2625 |
| Rough Draft Brewing Company | 8830 Rehco Rd, Ste D, San Diego, California, 92121, United States | 32.88409 | -117.1711 |
| Ruhstaller Brewery | 726 K St, Sacramento, California, 95814, United States | 38.58007 | -121.4974 |
| Russian River Brewing Company | 725 4th St., Santa Rosa, California, 95404, United States | 38.44145 | -122.7120 |
| S27 Alehouse and Brewery | 461 Perrymont Ave, San Jose, California, 95125, United States | 37.29879 | -121.8721 |
| Saint Archer Brewing Company (Tenth & Blake - Molson Coors) | 9550 Distrubution Ave, San Diego, California, 92121, United States | 32.88005 | -117.1628 |
| San Diego Brewing Company | 10450 Friars Rd, San Diego, California, 92120, United States | 32.79107 | -117.0987 |
| Santa Maria Brewing Company San Luis Obispo | 675 Clarion Ct, San Luis Obispo, California, 93401, United States | 35.24422 | -120.6460 |
| Scholb Premium Ales | 2964 Columbia Street, Torrance, California, 90503, United States | 33.84410 | -118.3395 |
| Seabright Brewery | 519 Seabright Ave, Santa Cruz, California, 95062, United States | 36.96758 | -122.0079 |
| Second Chance Beer Company | 15378 Avenue of Sciences, #222, San Diego, California, 92128, United States | 32.99445 | -117.0809 |
| Seismic Brewing Company | 2870 Duke Ct, Santa Rosa, California, 95407, United States | 38.40830 | -122.7224 |
| Shady Oak Barrel House | 420 1st Street, Santa Rosa, California, 95401, United States | 38.43709 | -122.7155 |
| Shanty Shack Brewing | 138 Fern Street, Santa Cruz, California, 95060, United States | 36.98597 | -122.0308 |
| Shapeshifters Cinema and Brewery | 567 5th St Oakland, CA, Oakland, California, 94607, United States | 37.79933 | -122.2783 |
| Shoots | 602 SOUTH TREMONT ST. STE 101, Oceanside, California, 92054, United States | 33.18913 | -117.3749 |
| SLO Brew | 736 Higuera St, San Luis Obispo, California, 93401, United States | 35.27928 | -120.6640 |
| Smog City Brewing | 1901 Del Amo Blvd, Ste B, Torrance, California, 90501, United States | 33.84690 | -118.3133 |
| SoCal Beer Company | 18226 Ventura Blvd. Suite 208, Los Angeles, California, 91356, United States | 34.16624 | -118.5299 |
| Societe Brewing Company | 8262 Clairemont Mesa Blvd, San Diego, California, 92111, United States | 32.83284 | -117.1469 |
| South O Brewing | 1575 South Coast Highway, Oceanside, California, 92054, United States | 33.18000 | -117.3663 |
| Southern Pacific Brewing | 620 Treat Ave, San Francisco, California, 94110, United States | 37.76017 | -122.4138 |
| SouthNorte Beer Company | 1205 Knoxville St, San Diego, California, 92110, United States | 32.77200 | -117.2048 |
| Standard Deviant Brewing | 280 14th St, San Francisco, California, 94110, United States | 37.76835 | -122.4197 |
| Stave & Nail Brewing Company | 1325 Grand Ave, Ste 107, San Marcos, California, 92078, United States | 33.14310 | -117.1923 |
| Stone Brewing - Liberty Station (Sapporo) | 2816 Historic Decatur Rd, #116‎, San Diego, California, 92106, United States | 32.73976 | -117.2112 |
| Strike Brewing Company | 2099 S 10th St, Ste 30, San Jose, California, 95112, United States | 37.31051 | -121.8570 |
| Stumblefoot Brewing Company | 1784 La Costa Meadows Dr #103, San Marcos, California, 92078, United States | 33.10423 | -117.2196 |
| Sufferfest Beer Company (Sierra Nevada) | 2147 Greenwich Street, San Francisco, California, 94123, United States | 37.79900 | -122.4350 |
| Summer Fox | 6585 N Santa Fe Ave, Fresno, California, 93722, United States | 36.83284 | -119.8784 |
| Sunny Bev | 610 VENEZIA AVENUE SUITE A, Los Angeles, California, 90291, United States | 33.98976 | -118.4595 |
| Sunset Reservoir Brewing Company | 1735 Noriega St, San Francisco, California, 94122, United States | 37.75393 | -122.4823 |
| TapRoom Beer Co | 2000 El Cajon Blvd, San Diego, California, 92104, United States | 32.75531 | -117.1437 |
| The Barn Brewery | 2850 El Cajon Blvd, Ste 3, San Diego, California, 92104, United States | 32.75536 | -117.1326 |
| The Bell Marker Brewery & Kitchen | 602 Broadway, San Diego, California, 92101, United States | 32.71576 | -117.1592 |
| The Dudes | 1840 W 208th St, Torrance, California, 90501, United States | 33.84181 | -118.3108 |
| The Gentleman Scholar | 2285 Westwood Boulevard, Los Angeles, California, 90064, United States | 34.04261 | -118.4307 |
| The Hop Concept | 155 Mata Way #104, San Marcos, California, 92069, United States | 33.14062 | -117.1498 |
| The Original 40 Brewing Company | 3117 University Ave, San Diego, California, 92104, United States | 32.74841 | -117.1267 |
| The Rare Barrel (Cellarmaker) | 940 Parker St, Berkeley, California, 94710, United States | 37.85867 | -122.2921 |
| Third Street Aleworks | 610 3rd St, Santa Rosa, California, 95404, United States | 38.43970 | -122.7132 |
| Thorn Brewing / Thorn Street Brewery | 3174 Thorn St, San Diego, California, 92104, United States | 32.73932 | -117.1255 |
| Tilt Brewing Company | Highlights info row image 357 E Taylor Street, San Jose, California, 95112, United States | 37.35264 | -121.8929 |
| Tiny Bubbles Brewing Company | 155 Mata Way #104, San Marcos, California, 92069, United States | 33.14062 | -117.1498 |
| Tioga-Sequoia Brewing Company | 746 Broadway St, Fresno, California, 93721, United States | 36.73070 | -119.7883 |
| Touchstone Brewing | 116 N 16th Street, Sacramento, California, 95811, United States | 38.58916 | -121.4805 |
| Towne Park Brew | 1566 W Lincoln Ave, Anaheim, California, 92801, United States | 33.83956 | -117.8960 |
| Track 7 Brewing Company | 3747 W Pacific Ave, Ste F, Sacramento, California, 95820, United States | 38.53970 | -121.4821 |
| Triple Rock Brewery & Alehouse | 1920 Shattuck Ave, Berkeley, California, 94704, United States | 37.87338 | -122.2687 |
| Triple Voodoo Brewing | 3145 Geary Blvd, Suite 410, San Francisco, California, 94118-3316, United States | 37.78170 | -122.4526 |
| Two Roots Brewing Company | 4896 Newport Ave, San Diego, California, 92107, United States | 32.74578 | -117.2492 |
| United Brands Company | 10940 Wilshire Boulevard, Suite 1600, Los Angeles, California, 90024, United States | 34.05831 | -118.4454 |
| Uproar Brewing Company | 439 S. First Street, San Jose, California, 95113, United States | 37.32942 | -121.8856 |
| Urban Roots Brewing & Smokehouse | 1322 V St, Sacramento, California, 95818, United States | 38.56583 | -121.4946 |
| Venice Ale House | 2 Rose Ave, Los Angeles, California, 90291, United States | 33.99461 | -118.4804 |
| Venice Beach Beer Company | 642 Rose Ave, Los Angeles, California, 90291, United States | 33.99979 | -118.4707 |
| Venice Duck Brewery | 4238 Coolidge Ave, Los Angeles, California, 90055, United States | 34.00149 | -118.4177 |
| Wavelength Brewing Company | 236 Main St, Vista, California, 92084, United States | 33.20254 | -117.2419 |
| Weed Cellars | 927 N La Cienega Blvd, Los Angeles, California, 90069, United States | 34.08773 | -118.3765 |
| White Labs | 9495 Candida Street, San Diego, California, 92126, United States | 32.89619 | -117.1218 |
| Wiretap Brewing | 341 S Ave 17, Ste B, Los Angeles, California, 90031, United States | 34.06855 | -118.2220 |
| Woodfour Brewing Company | 6780 Depot St, #160, Sebastopol, California, 95472, United States | 38.40288 | -122.8221 |
| Woodhouse Blending and Brewing | 119 Madrone St, Santa Cruz, California, 95060, United States | 36.98282 | -122.0299 |
| Woods Beer & Wine | 1701 Telegraph Ave, Oakland, California, 94612, United States | 37.80691 | -122.2704 |
| Yorkshire Square Brewery | 1109 Van Ness Ave, Torrance, California, 90501, United States | 33.83726 | -118.3164 |
| Bivouac Ciderworks | 3986 30th St, San Diego, California, 92104, United States | 32.75006 | -117.1302 |
| Bonny Doon Vineyard | 328 Ingalls Street, Santa Cruz, California, 95060, United States | 36.95890 | -122.0463 |
| California Cider Company | 2064 Gravenstein Hwy N, Building 4, Sebastopol, California, 95472, United States | 38.38034 | -122.8020 |
| Castellum Ciders | 1745 National Avenue, San Diego, California, 92113, United States | 32.70241 | -117.1477 |
| Devoto Orchards | 655 Gold Ridge Road, Sebastopol, California, 95472, United States | 38.38911 | -122.8652 |
| Domaine Le Mieux / See Canyon Cider | 2885 See Canyon Road, San Luis Obispo, California, 93405, United States | 35.22466 | -120.7332 |
| Ethic Ciders | 8490 Occidental Road, Sebastopol, California, 95472, United States | 38.42503 | -122.8573 |
| FoxCraft Hard Cider Company | 409 Mendocino Ave, Santa Rosa, California, 95401, United States | 38.44121 | -122.7146 |
| Guthrie CiderWorks | 6496 Marindustry Dr, Ste D, San Diego, California, 92121, United States | 32.88131 | -117.1771 |
| Horse & Plow | 1272 Gravenstein Hwy N, Sebastopol, California, 95472, United States | 38.41339 | -122.8437 |
| Horse and Plow | 1272 Gravenstein Hwy N, Sebastopol, California, 95472, United States | 38.41339 | -122.8437 |
| Raging Cider & Mead | 177 Newport Dr, Ste B, San Marcos, California, 92069, United States | 33.14342 | -117.1881 |
| Serpentine Cider | 8665 Miralani Dr, #100, San Diego, California, 92126, United States | 32.89579 | -117.1376 |
| SLO Cider Co. | 3419 Roberto Ct Suite C, San Luis Obispo, California, 93401, United States | 35.25943 | -120.6443 |
| Sonoma Cider (Full Circle Brewing) | 712 FULTON ST, Fresno, California, 93721, United States | 36.73112 | -119.7870 |
| Specific Gravity Cider Company | 708 Gravenstein Hwy North #174, Sebastopol, California, 95472, United States | 38.40855 | -122.8397 |
| Sutton Cellars | 601 22nd Street, San Francisco, California, 94107, United States | 37.75794 | -122.3874 |
| Tag + Jug Cider Company | 995 9th St, San Francisco, California, 94130, United States | 37.82540 | -122.3700 |
| Thomas Brothers Hard Cider Company | 2323 Fourth St, Ste. B, Berkeley, California, 94710, United States | 37.86267 | -122.2982 |
| Twin Hills Hard Cider | 1689 Pleasant Hill Rd, Sebastopol, California, 95472-4916, United States | 38.37907 | -122.8331 |
| Two Broads Ciderworks | 3427 Roberto Court Suite 130, San Luis Obispo, California, 93401, United States | 35.25939 | -120.6443 |
| Two Rivers Cider Company | 4311 Attawa Ave, Sacramento, California, 95882, United States | 38.53593 | -121.4845 |
| Bronto Mead | 9235 Trade Pl, Ste D, San Diego, California, 92126, United States | 32.89200 | -117.1533 |
| Honey Pot Meadery | 5120 E. La Palma #104, Anaheim, California, 92807, United States | 33.85975 | -117.7968 |
| Meadiocrity Mead | 1365 Grand Avenue, Suite 100, San Marcos, California, 92078, United States | 33.14340 | -117.1931 |
| Den Sake | 2311 Magnolia St, Oakland, California, 94607, United States | 37.81679 | -122.2848 |
| Setting Sun Sake | 8680 Miralani Dr, San Diego, California, 92126, United States | 32.89589 | -117.1374 |
| Takara Sake USA | 708 Addison St, Berkeley, California, 94710, United States | 37.86611 | -122.3001 |
data_1 <- ca_addresses_cleaned %>%
inner_join(breweries, by = "name") %>%
select(city, long, lat, name, type)
data_1 %>%
inner_join(data_1, by = "city") %>%
group_by(city) %>%
mutate(dist = distHaversine(cbind(long.x, lat.x), cbind(long.y, lat.y))) %>%
filter(!dist == 0) %>%
summarize(avg_dist = mean(dist)) %>%
arrange(avg_dist) %>%
kable() %>%
kable_styling() %>%
scroll_box(width = "100%", height = "400px")| city | avg_dist |
|---|---|
| Berkeley | 2460.515 |
| Torrance | 2497.924 |
| Sebastopol | 3008.522 |
| Santa Cruz | 3221.302 |
| San Marcos | 3264.934 |
| Vista | 3363.720 |
| Oakland | 3759.556 |
| San Luis Obispo | 3799.628 |
| San Jose | 3968.907 |
| Santa Rosa | 4015.131 |
| San Francisco | 4914.723 |
| Oceanside | 5649.928 |
| Anaheim | 5771.952 |
| Sacramento | 5851.130 |
| Fresno | 7787.670 |
| San Diego | 12067.006 |
| Los Angeles | 17257.252 |
options(ggrepel.max.overlaps = Inf)
berkeley_data <- ca_addresses_cleaned %>%
inner_join(breweries) %>%
filter(city == "Berkeley")
berkeley_map <- get_map(location = "Berkeley", zoom = 13, source = "stadia", maptype = "stamen_toner_lite")
ggmap(berkeley_map) +
geom_point(data = berkeley_data, aes(x = long, y = lat, color = type), alpha = 0.6, size = 5) +
geom_text_repel(data = berkeley_data, aes(x = long, y = lat, label = name), size = 5, point.padding = 0.5) +
theme_void() +
labs(title = "Breweries in Berkeley")
Part 2 – Office Express
Database connection
db = dbConnect(MySQL(),
user = 'ofx_user',
password = 'TestyTester#2024',
dbname = 'ofx',
host = 'ballenger.wlu.edu')
category <- fetch(dbSendQuery(db, "SELECT * FROM category"), n=-1)
product <- fetch(dbSendQuery(db, "SELECT * FROM product"), n=-1)
order_product <- fetch(dbSendQuery(db, "SELECT * FROM order_product"), n=-1)
buyer <- fetch(dbSendQuery(db, "SELECT * FROM buyer"), n=-1)
location <- fetch(dbSendQuery(db, "SELECT *FROM location"), n=-1)
orders <- fetch(dbSendQuery(db, "SELECT *FROM orders"), n=-1)Data Preperation and EDA
#location_long_lat <- location %>%
#distinct(City, State) %>%
#mutate(city_state = paste(City, State, sep = ", ")) %>%
#tidygeocoder::geocode(city_state, method = "arcgis")
#write.csv(location_long_lat, "/home/ballengerb@ad.wlu.edu/BUS_317_01/wolffa24/Data/location_long_lat.csv", row.names = FALSE)location_long_lat <- read.csv("/home/ballengerb@ad.wlu.edu/BUS_317_01/wolffa24/Data/location_long_lat.csv") %>%
rename_with(tolower)data_cleaning <- function(data) {
data %>%
na.omit %>%
rename_with(tolower)
}
eda <- function(data) {
glimpse(data)
data%>%
head(20) %>%
kable() %>%
kable_styling() %>%
scroll_box(width = "100%", height = "400px")
}category <- data_cleaning(category)
eda(category)## Rows: 17
## Columns: 2
## $ sub_category <chr> "Accessories", "Appliances", "Art", "Binders", "Bookcases…
## $ category <chr> "Technology", "Office Supplies", "Office Supplies", "Offi…| sub_category | category |
|---|---|
| Accessories | Technology |
| Appliances | Office Supplies |
| Art | Office Supplies |
| Binders | Office Supplies |
| Bookcases | Furniture |
| Chairs | Furniture |
| Copiers | Technology |
| Envelopes | Office Supplies |
| Fasteners | Office Supplies |
| Furnishings | Furniture |
| Labels | Office Supplies |
| Machines | Technology |
| Paper | Office Supplies |
| Phones | Technology |
| Storage | Office Supplies |
| Supplies | Office Supplies |
| Tables | Furniture |
product <- data_cleaning(product)
eda(product)## Rows: 1,862
## Columns: 3
## $ product_id <chr> "FUR-BO-10000112", "FUR-BO-10000330", "FUR-BO-10000362", …
## $ product_name <chr> "Bush Birmingham Collection Bookcase, Dark Cherry", "Saud…
## $ sub_category <chr> "Bookcases", "Bookcases", "Bookcases", "Bookcases", "Book…| product_id | product_name | sub_category |
|---|---|---|
| FUR-BO-10000112 | Bush Birmingham Collection Bookcase, Dark Cherry | Bookcases |
| FUR-BO-10000330 | Sauder Camden County Barrister Bookcase, Planked Cherry Finish | Bookcases |
| FUR-BO-10000362 | Sauder Inglewood Library Bookcases | Bookcases |
| FUR-BO-10000468 | O’Sullivan 2-Shelf Heavy-Duty Bookcases | Bookcases |
| FUR-BO-10000711 | Hon Metal Bookcases, Gray | Bookcases |
| FUR-BO-10000780 | O’Sullivan Plantations 2-Door Library in Landvery Oak | Bookcases |
| FUR-BO-10001337 | O’Sullivan Living Dimensions 2-Shelf Bookcases | Bookcases |
| FUR-BO-10001519 | O’Sullivan 3-Shelf Heavy-Duty Bookcases | Bookcases |
| FUR-BO-10001567 | Bush Westfield Collection Bookcases, Dark Cherry Finish, Fully Assembled | Bookcases |
| FUR-BO-10001601 | Sauder Mission Library with Doors, Fruitwood Finish | Bookcases |
| FUR-BO-10001608 | Hon Metal Bookcases, Black | Bookcases |
| FUR-BO-10001619 | O’Sullivan Cherrywood Estates Traditional Bookcase | Bookcases |
| FUR-BO-10001798 | Bush Somerset Collection Bookcase | Bookcases |
| FUR-BO-10001811 | Atlantic Metals Mobile 5-Shelf Bookcases, Custom Colors | Bookcases |
| FUR-BO-10001918 | Sauder Forest Hills Library with Doors, Woodland Oak Finish | Bookcases |
| FUR-BO-10001972 | O’Sullivan 4-Shelf Bookcase in Odessa Pine | Bookcases |
| FUR-BO-10002202 | Atlantic Metals Mobile 2-Shelf Bookcases, Custom Colors | Bookcases |
| FUR-BO-10002206 | Bush Saratoga Collection 5-Shelf Bookcase, Hanover Cherry, *Special Order | Bookcases |
| FUR-BO-10002213 | DMI Eclipse Executive Suite Bookcases | Bookcases |
| FUR-BO-10002268 | Sauder Barrister Bookcases | Bookcases |
order_product <- data_cleaning(order_product)
eda(order_product)## Rows: 9,986
## Columns: 6
## $ order_id <chr> "CA-2011-100006", "CA-2011-100090", "CA-2011-100…
## $ product_id <chr> "TEC-PH-10002075", "FUR-TA-10003715", "OFF-BI-10…
## $ quantity <int> 3, 3, 6, 6, 1, 2, 3, 2, 3, 2, 3, 3, 6, 2, 4, 2, …
## $ unit_price <dbl> 125.990, 167.496, 32.784, 15.176, 3.928, 1.184, …
## $ discount <dbl> 0.0, 0.2, 0.2, 0.2, 0.2, 0.2, 0.2, 0.0, 0.3, 0.2…
## $ gross_profit_per_unit <dbl> 36.5371, -29.3118, 11.4744, 5.3116, 1.3257, 0.41…| order_id | product_id | quantity | unit_price | discount | gross_profit_per_unit |
|---|---|---|---|---|---|
| CA-2011-100006 | TEC-PH-10002075 | 3 | 125.990 | 0.0 | 36.5371 |
| CA-2011-100090 | FUR-TA-10003715 | 3 | 167.496 | 0.2 | -29.3118 |
| CA-2011-100090 | OFF-BI-10001597 | 6 | 32.784 | 0.2 | 11.4744 |
| CA-2011-100293 | OFF-PA-10000176 | 6 | 15.176 | 0.2 | 5.3116 |
| CA-2011-100328 | OFF-BI-10000343 | 1 | 3.928 | 0.2 | 1.3257 |
| CA-2011-100363 | OFF-FA-10000611 | 2 | 1.184 | 0.2 | 0.4144 |
| CA-2011-100363 | OFF-PA-10004733 | 3 | 6.336 | 0.2 | 2.2968 |
| CA-2011-100391 | OFF-PA-10001471 | 2 | 7.310 | 0.0 | 3.3626 |
| CA-2011-100678 | FUR-CH-10002602 | 3 | 105.686 | 0.3 | -6.0392 |
| CA-2011-100678 | OFF-AR-10001868 | 2 | 1.344 | 0.2 | 0.5040 |
| CA-2011-100678 | OFF-EN-10000056 | 3 | 49.784 | 0.2 | 16.8021 |
| CA-2011-100678 | TEC-AC-10000474 | 3 | 75.992 | 0.2 | 9.4990 |
| CA-2011-100706 | FUR-FU-10002268 | 6 | 4.910 | 0.0 | 1.6203 |
| CA-2011-100706 | TEC-AC-10001314 | 2 | 49.990 | 0.0 | 3.9992 |
| CA-2011-100762 | OFF-AR-10000380 | 4 | 37.980 | 0.0 | 11.3940 |
| CA-2011-100762 | OFF-LA-10003930 | 2 | 98.310 | 0.0 | 48.1719 |
| CA-2011-100762 | OFF-PA-10001815 | 3 | 48.040 | 0.0 | 23.0592 |
| CA-2011-100762 | OFF-PA-10004082 | 2 | 7.980 | 0.0 | 3.9900 |
| CA-2011-100860 | OFF-LA-10001982 | 5 | 3.750 | 0.0 | 1.8000 |
| CA-2011-100867 | TEC-PH-10004922 | 6 | 53.592 | 0.2 | 3.3495 |
buyer <- data_cleaning(buyer)
eda(buyer)## Rows: 792
## Columns: 4
## $ buyer_id <chr> "AA-10315", "AA-10375", "AA-10480", "AA-10645", "AB-10015",…
## $ last_name <chr> "Avila", "Armold", "Allen", "Andreadi", "Bergman", "Bellava…
## $ first_name <chr> "Alex", "Allen", "Andrew", "Anna", "Aaron", "Adam", "Adrian…
## $ type <chr> "Consumer", "Consumer", "Consumer", "Consumer", "Consumer",…| buyer_id | last_name | first_name | type |
|---|---|---|---|
| AA-10315 | Avila | Alex | Consumer |
| AA-10375 | Armold | Allen | Consumer |
| AA-10480 | Allen | Andrew | Consumer |
| AA-10645 | Andreadi | Anna | Consumer |
| AB-10015 | Bergman | Aaron | Consumer |
| AB-10060 | Bellavance | Adam | Home Office |
| AB-10105 | Barton | Adrian | Consumer |
| AB-10150 | Bixby | Aimee | Consumer |
| AB-10165 | Barnes | Alan | Consumer |
| AB-10255 | Ballentine | Alejandro | Home Office |
| AB-10600 | Blume | Ann | Corporate |
| AC-10420 | Crouse | Alyssa | Corporate |
| AC-10450 | Cox | Amy | Consumer |
| AC-10615 | Chong | Ann | Corporate |
| AC-10660 | Chung | Anna | Consumer |
| AD-10180 | Dominguez | Alan | Home Office |
| AF-10870 | Ferguson | Art | Consumer |
| AF-10885 | Foster | Art | Consumer |
| AG-10270 | Grove | Alejandro | Consumer |
| AG-10300 | Gannaway | Aleksandra | Corporate |
location_long_lat <- data_cleaning(location_long_lat)
eda(location_long_lat)## Rows: 603
## Columns: 5
## $ city <chr> "Holyoke", "Leominster", "Marlborough", "Andover", "Lawrenc…
## $ state <chr> "Massachusetts", "Massachusetts", "Massachusetts", "Massach…
## $ city_state <chr> "Holyoke, Massachusetts", "Leominster, Massachusetts", "Mar…
## $ lat <dbl> 42.20184, 42.52586, 42.34695, 42.65525, 42.70847, 42.64543,…
## $ long <dbl> -72.62192, -71.76013, -71.54718, -71.13967, -71.16179, -71.…| city | state | city_state | lat | long |
|---|---|---|---|---|
| Holyoke | Massachusetts | Holyoke, Massachusetts | 42.20184 | -72.62192 |
| Leominster | Massachusetts | Leominster, Massachusetts | 42.52586 | -71.76013 |
| Marlborough | Massachusetts | Marlborough, Massachusetts | 42.34695 | -71.54718 |
| Andover | Massachusetts | Andover, Massachusetts | 42.65525 | -71.13967 |
| Lawrence | Massachusetts | Lawrence, Massachusetts | 42.70847 | -71.16179 |
| Lowell | Massachusetts | Lowell, Massachusetts | 42.64543 | -71.30740 |
| Beverly | Massachusetts | Beverly, Massachusetts | 42.55216 | -70.88268 |
| Franklin | Massachusetts | Franklin, Massachusetts | 42.08243 | -71.39672 |
| Cambridge | Massachusetts | Cambridge, Massachusetts | 42.36525 | -71.10501 |
| Malden | Massachusetts | Malden, Massachusetts | 42.42650 | -71.07355 |
| Everett | Massachusetts | Everett, Massachusetts | 42.40850 | -71.05418 |
| Revere | Massachusetts | Revere, Massachusetts | 42.40997 | -71.01240 |
| Quincy | Massachusetts | Quincy, Massachusetts | 42.25143 | -71.00215 |
| New Bedford | Massachusetts | New Bedford, Massachusetts | 41.63405 | -70.92766 |
| Warwick | Rhode Island | Warwick, Rhode Island | 41.69865 | -71.46018 |
| Woonsocket | Rhode Island | Woonsocket, Rhode Island | 42.00097 | -71.50547 |
| Providence | Rhode Island | Providence, Rhode Island | 41.82446 | -71.41275 |
| Cranston | Rhode Island | Cranston, Rhode Island | 41.77896 | -71.43581 |
| Nashua | New Hampshire | Nashua, New Hampshire | 42.75787 | -71.46395 |
| Concord | New Hampshire | Concord, New Hampshire | 43.20957 | -71.53729 |
location <- data_cleaning(location)
eda(location)## Rows: 631
## Columns: 4
## $ postal_code <chr> "01040", "01453", "01752", "01810", "01841", "01852", "019…
## $ city <chr> "Holyoke", "Leominster", "Marlborough", "Andover", "Lawren…
## $ state <chr> "Massachusetts", "Massachusetts", "Massachusetts", "Massac…
## $ region <chr> "East", "East", "East", "East", "East", "East", "East", "E…| postal_code | city | state | region |
|---|---|---|---|
| 01040 | Holyoke | Massachusetts | East |
| 01453 | Leominster | Massachusetts | East |
| 01752 | Marlborough | Massachusetts | East |
| 01810 | Andover | Massachusetts | East |
| 01841 | Lawrence | Massachusetts | East |
| 01852 | Lowell | Massachusetts | East |
| 01915 | Beverly | Massachusetts | East |
| 02038 | Franklin | Massachusetts | East |
| 02138 | Cambridge | Massachusetts | East |
| 02148 | Malden | Massachusetts | East |
| 02149 | Everett | Massachusetts | East |
| 02151 | Revere | Massachusetts | East |
| 02169 | Quincy | Massachusetts | East |
| 02740 | New Bedford | Massachusetts | East |
| 02886 | Warwick | Rhode Island | East |
| 02895 | Woonsocket | Rhode Island | East |
| 02908 | Providence | Rhode Island | East |
| 02920 | Cranston | Rhode Island | East |
| 03060 | Nashua | New Hampshire | East |
| 03301 | Concord | New Hampshire | East |
orders <- data_cleaning(orders)
eda(orders)## Rows: 5,009
## Columns: 6
## $ order_id <chr> "CA-2011-100006", "CA-2011-100090", "CA-2011-100293", "CA-…
## $ order_date <chr> "2011-09-07", "2011-07-08", "2011-03-14", "2011-01-29", "2…
## $ ship_date <chr> "2011-09-13", "2011-07-12", "2011-03-18", "2011-02-04", "2…
## $ ship_mode <chr> "Standard Class", "Standard Class", "Standard Class", "Sta…
## $ buyer_id <chr> "DK-13375", "EB-13705", "NF-18475", "JC-15340", "JM-15655"…
## $ postal_code <chr> "10024", "94122", "32216", "10024", "85301", "10035", "770…| order_id | order_date | ship_date | ship_mode | buyer_id | postal_code |
|---|---|---|---|---|---|
| CA-2011-100006 | 2011-09-07 | 2011-09-13 | Standard Class | DK-13375 | 10024 |
| CA-2011-100090 | 2011-07-08 | 2011-07-12 | Standard Class | EB-13705 | 94122 |
| CA-2011-100293 | 2011-03-14 | 2011-03-18 | Standard Class | NF-18475 | 32216 |
| CA-2011-100328 | 2011-01-29 | 2011-02-04 | Standard Class | JC-15340 | 10024 |
| CA-2011-100363 | 2011-04-08 | 2011-04-15 | Standard Class | JM-15655 | 85301 |
| CA-2011-100391 | 2011-05-25 | 2011-05-29 | Standard Class | BW-11065 | 10035 |
| CA-2011-100678 | 2011-04-18 | 2011-04-22 | Standard Class | KM-16720 | 77095 |
| CA-2011-100706 | 2011-12-16 | 2011-12-18 | Second Class | LE-16810 | 22153 |
| CA-2011-100762 | 2011-11-24 | 2011-11-29 | Standard Class | NG-18355 | 49201 |
| CA-2011-100860 | 2011-03-26 | 2011-03-30 | Second Class | CS-12505 | 91767 |
| CA-2011-100867 | 2011-10-19 | 2011-10-24 | Standard Class | EH-14125 | 90712 |
| CA-2011-100881 | 2011-03-28 | 2011-04-01 | Standard Class | DR-12940 | 87105 |
| CA-2011-100895 | 2011-06-02 | 2011-06-06 | Standard Class | SV-20785 | 30076 |
| CA-2011-100916 | 2011-10-21 | 2011-10-26 | Standard Class | FH-14275 | 23602 |
| CA-2011-100972 | 2011-11-19 | 2011-11-24 | Second Class | DB-13360 | 84106 |
| CA-2011-101147 | 2011-12-02 | 2011-12-04 | First Class | MC-17575 | 60623 |
| CA-2011-101175 | 2011-12-09 | 2011-12-14 | Standard Class | DM-12955 | 85204 |
| CA-2011-101266 | 2011-08-27 | 2011-08-30 | Second Class | MM-17920 | 22153 |
| CA-2011-101364 | 2011-12-22 | 2011-12-26 | Standard Class | TW-21025 | 10011 |
| CA-2011-101392 | 2011-12-07 | 2011-12-13 | Standard Class | AS-10630 | 98103 |
list_df <- c("category", "product", "order_product", "buyer", "order", "location")
for (df_name in list_df) {
df <- get(df_name)
for(column in names(df)) {
if (!column %in% c("product_id", "order_id", "buyer_id",
"city", "postal_code", "ship_date", "ship_mode",
"sub_category", "last_name", "first_name", "product_name")) {
if (is.numeric(df[[column]])) {
hist <- ggplot(data = df, aes_string(x = column)) +
geom_histogram(bins = 30) +
theme_minimal() +
labs(title = paste("Histogram of", column))
print(hist)
} else {
p <- ggplot(data = df, aes_string(x = column)) +
geom_bar() +
theme_minimal() +
labs(title = paste("Bar Chart of", column)) +
theme(axis.text.x = element_text(angle = 45, hjust = 1))
print(p)
}}}}
From the Category bar chart we can conclude that office supplies are the products that are most sold followed by furniture and technology. The histogram for quantity indicates a rights skewed unimodal distribution with the most common purchased quantities being 2 and 3. The histogram of unit_price shows a right skewed unimodal distribution with the most common price being under 100 dollars. The histogram for discounts shows the most common discounts are either 0%, or no discount at all, and 20%. The histogram for gross profit per unit shows a mostly normal distribution with the average profit being slightly greater than 0. The bar chart of for the type of consumer indicates that consumers are the most prominent customers followed by corporate and home offices. The bar chart for the distribution of state shows the states with the most purchases are California and Texas, most likely due to the their large populations. Finally, the bar chart for region shows the central and west regions are the greatest consumers followed by south and east.
1. Key Finding - Geospacial Mapping
key_finding_1 <- order_product %>%
inner_join(orders) %>%
inner_join(location) %>%
inner_join(location_long_lat) %>%
inner_join(buyer) %>%
select(long, lat, quantity, city, type) %>%
na.omit() %>%
group_by(city, long, lat, type) %>%
summarise(total_quantity = sum(quantity, na.rm = TRUE), .groups = "drop")
get_map(location = 'usa', zoom = 4, source = "stadia", maptype = "stamen_toner_lite") %>%
ggmap(base_layer = ggplot(key_finding_1, aes(x = long, y = lat, size = total_quantity, color = type))) +
geom_point(alpha = .5) +
theme_void() +
labs(title = "Order Quantities by Cities in the US")
The visualization above is map of the order quantities by cities by type in the US. The size of the dot is relative to the number of orders and the color is associated with the type of buyer. As expected, metropolitan areas in the northeast, such as New York, Washington, and Boston, and the west cost, such as San Francisco, Los Angeles and Seattle, have the highest order quantities in the country. Furthermore, the type of buyer is distributed evenly throughout the county.
2. Key Finding - Seasonal Distributions
orders %>%
inner_join(order_product) %>%
mutate(
month = month(ymd(order_date)),
season = case_when(
month %in% 3:5 ~ "Spring",
month %in% 6:8 ~ "Summer",
month %in% 9:11 ~ "Fall",
month %in% c(12, 1, 2) ~ "Winter"
)) %>%
inner_join(order_product)%>%
inner_join(product) %>%
inner_join(category) %>%
group_by(category, season) %>%
summarise(number_sold = sum(quantity), .groups = "drop") %>%
ggplot(aes(x = season, y = number_sold, fill = season)) +
geom_bar(stat = "identity") +
facet_wrap(~ category) +
labs(title = "Seasonal Sales by Product Category",
x = "Season",
y = "Number Sold") +
theme_minimal() +
theme(axis.text.x = element_text(angle = 45, hjust = 1))
The visualization above represents seasonal sales by product category. From the graph we can concluded that most sales occur during fall for each product category. Furthermore, winter, summer, and spring average the same number of sales for the three product categories. Office supplies produce significantly more sales than the other product categories.
3. Key Finding - Worst Preforming Sub-Categories
order_product %>%
inner_join(product) %>%
group_by(sub_category) %>%
summarize(avg_margin = mean(gross_profit_per_unit / unit_price),
avg_discount = mean(discount)) %>%
arrange(avg_margin) %>%
slice(1:10) %>%
mutate(sub_category = factor(sub_category, levels = sub_category)) %>%
ggplot(aes(x = sub_category, y = avg_margin, fill = avg_discount)) +
geom_bar(stat = "identity", position = "identity") +
theme_minimal() +
labs(title = "Bar Chart of Top 10 Worst Margins by Product Sub-Categories",
x = "Sub-Category",
y = "Average Profit Margin",
fill = "Average Discount (%)") +
theme(axis.text.x = element_text(angle = 45, hjust = 1))
The graph above represents the top 10 worst margins by product sub-category. Furthermore, the color represents the average discount rate applied to that product when sold. From the graph we can conclude that binders have the worst margins followed by appliances and tables. Finally, from the graph we can also see the sub-categories with negative margins have higher discount rates than the products with positive margins for the worst performing sub-categories.
4. Key Finding - South FLorida Analysis
key_finding_4 <- order_product %>%
inner_join(orders) %>%
inner_join(location) %>%
inner_join(location_long_lat) %>%
inner_join(buyer) %>%
filter(state == "Florida") %>%
group_by(long, lat, type) %>%
summarise(avg_margin = mean(gross_profit_per_unit / unit_price),
total_quantity = sum(quantity, na.rm = TRUE),
.groups = "drop")
get_map(location = 'Fort Lauderdale', zoom = 9, source = "stadia", maptype = "stamen_toner_lite") %>%
ggmap(base_layer = ggplot(key_finding_4, aes(x = long, y = lat, size = total_quantity, color = avg_margin))) +
geom_point(alpha = .5) +
scale_size(range = c(5, 10)) +
theme_void() +
labs(title = "Order Quantites and Margins in South Florida",
color = "Margins",
size = "Total Quantity")
The visualization above shows a map of South Florida with dots at each of the location products were sold; the size of the dots represents the total quantity purchased and the color represents the average gross profit per unit sold. The graph shows the distributions of quantity sizes to be mostly uniform and average profit to be at or near zero. Finally, the graph also shows the locations of the purchases to be decentralized in South Florida.
5. Key Finding - Bar Chart of Margins
order_product %>%
inner_join(orders) %>%
inner_join(location) %>%
select(city, quantity, unit_price, gross_profit_per_unit, region) %>%
group_by(city, region) %>%
summarize(avg_margin = mean(gross_profit_per_unit / unit_price), .groups = "drop") %>%
arrange(desc(avg_margin)) %>%
slice_max(order_by = avg_margin, n = 25) %>%
ggplot(aes(x = reorder(city, desc(avg_margin)), y = avg_margin, fill = region)) +
geom_bar(stat = "identity", position = "identity") +
theme_minimal() +
labs(title = "Bar Chart of Top 25 Cities by Highest Margins",
x = "City",
y = "Average Margin",
fill = "Region") +
theme(axis.text.x = element_text(angle = 45, hjust = 1))
The visualization above represents the top 25 highest margins by city, which are colored by region. The city with the highest margin is Atlantic city with 50%, followed by Grand Island and Summertime. Furthermore, the coloration of the regions indicates each region is evenly distributed in terms of high margins. In other word, there is not a standout regions with high profit margins.
6. Key Finding - Scatter Plot: Discount Rate/Profit Margin
order_product %>%
inner_join(product) %>%
inner_join(category) %>%
ggplot(aes(x = discount, y = gross_profit_per_unit / unit_price, color = category)) +
geom_point() +
geom_smooth(method = "lm", se = FALSE) +
labs(
title = "Relationship between Discount and Profit Margin",
x = "Discount Rate",
y = "Profit Margin")
The visualization above shows the relationship between profit margins and discount rate. From this graph we can conclude that products start reaching negative margins when sold at a discount rate of greater than 20%. Furthermore, we can conclude that each product category crosses the negative margin threshold at different discount rates with furniture being first, followed by office supplies and technology. In other words, discounted technology products retain positive profit margins at higher discount rates.
Project Log
Used the following link to find the distHaversine function: https://www.rdocumentation.org/packages/geosphere/versions/1.5-18/topics/distHaversine
The Pledge
I have neither given nor received unauthorized aid on this work.
Alex Wolff, 2024-04-18